[thelist] mysql count(*)
Scott Dexter
sgd at ti3.com
Tue Dec 12 11:31:04 CST 2000
>
> in cold fusion you can use the query variable RecordCount,
> which gives you
> the total number of records returned by the query, and i'm pretty sure
> there's a similar thingie in ASP, so on that basis, i did a
> quick search at
> www.php.net and i think pg_numrows might do what you want...
>
in ASP, the ADO Recordset object does have a RecordCount property, but it is
*only* populated when using a keyset or dynamic cursor. Since the default
(and fastest) is a forward-only cursor (MS calls it 'firehose' cause it just
spews the data out; the other cursors can maneuver about the data), the
property is unkown, and reported as -1. In other words, don't use it =(
sgd
More information about the thelist
mailing list