Re: how to move into a recordset?



Oli Filth said the following on 28/09/2005 12:17:
s4femod3 said the following on 28/09/2005 04:05:

y not try odbc_num_rows($query); ?

<...SNIP...>

Alternatively, why not include a COUNT(*) in your SELECT query?


Or another alternative, why not loop through the recordset and load it into an array?


Then you'll know the number of entries, and willl be free to walk it randomly, without needing any more ODBC commands.

--
Oli
.



Relevant Pages

  • split col into mutiple cols
    ... I have single col with 9000+ entries. ... What I am looking for is a formla that ... have no problem with this but I am needing the formula to split this into ... to spend day cutting and pasting.. ...
    (microsoft.public.excel)
  • Cronological sequence formula
    ... I'm needing a formula that will number my entries ... greasybob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7923 ...
    (microsoft.public.excel.misc)
  • Re: max value every N entries... how to
    ... entries... ... I was wrong about only needing to swap the 24 and ... Just transpose to get the column vector. ... maxarray = zeros; ...
    (comp.soft-sys.matlab)
  • Re: max value every N entries... how to
    ... entries... ... I was wrong about only needing to swap the 24 and ... Just transpose to get the column vector. ... did you really bother to try michael hosea's nice solution... ...
    (comp.soft-sys.matlab)
  • Re: max value every N entries... how to
    ... entries... ... I was wrong about only needing to swap the 24 and ... Just transpose to get the column vector. ... Mike ...
    (comp.soft-sys.matlab)