Skip to Content.
Sympa Menu

freetds - Help - I am going crazy...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Jay Van Vark <jay AT vanvark.net>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Help - I am going crazy...
  • Date: Mon, 05 Aug 2002 07:44:51 -0700


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






Archive powered by MHonArc 2.6.24.

Top of Page