FreeTDS Development Group

[Jay Van Vark <jay AT vanvark.net>]

I can't find a solution to getting the current number of rows from a select
query. I can't believe that there isn't one -- no one would be using this...

I am using the freeTDS from CVS and the odbc connection - I am using it
through PHP. I need to be able to get the number of rows before I fetch all
the rows or I need to be able to backup to the first row if I need to loop
through all the fetches (boy that would be slow).

I have been trying to get a second select after the first one executes with
the SELECT @@ROWCOUNT - which if done after the fetches returns just fine.
However, if I try to do the execute before the fetch, that fails - there are
results pending.

For some reason, even doing a select COUNT(*) from (other query) derivedtbl
- this seems to take for ever if I do the two queries one right after the
other, but run by itself -- it is fine...

Wow -- this is a royal pain...

Please any suggestions are welcome and appreciated...!


Jay Van Vark
'Guiding Positive Change in High-Tech Companies'
one box voicemail (866) 248-7670 x 6471
efax  (801) 659-7952

-- Great tool for advertising bid optimization, check out:
http://www.Promote4Less.com