Skip to Content.
Sympa Menu

freetds - Re: [freetds] Count number of row in a result

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: mbox843 AT webjorn.org, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Cc:
  • Subject: Re: [freetds] Count number of row in a result
  • Date: 26 Jan 2004 21:30:51 +0100

Il lun, 2004-01-26 alle 18:45, Mattias Webjorn Eriksson ha scritto:
> Hello.
> I want to know how many rows a query returns before I process it.
> Is there a way to determine how many rows a SELECT query returns when
> using dblib, just like dbnumcols()?
>
> I can't find it any function like that i the refernce manual nor when
> searching on the web.
>
> Regards
> Mattias W E

Just change database system :)
Well, it's not really a yoke, simply you can't... sql server return row
counts only after fetching rows. There are however some workaround:
- execute another statement to compute rows numbers (just issue "select
count(*) from table" before "select * from table")
- cache all data (very bad).

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page