[thelist] mysql count(*)

[Scott Dexter]

> 
> 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