[thelist] rs.PageCount

Scott Dexter sgd at ti3.com
Fri Jan 26 17:42:31 CST 2001


> Does anyone know why a rs.PageCount call in ASP would return 
> -1 when the
> recordset is filled with lots of goodness?

the default cursor used is a forward-only, read-only cursor. As such, ADO
doesn't populate the RecordCount or PageCount properties (because it never
knows what they are). You'll have to open the recordset as a keyset or
dynaset cursor, then you get your goodies. But beware, it seriously affects
performance. Better to write something to page through them after you have
the records (or re-think how you page through the recordset in the first
place) then lean on a keyset or dynaset cursor....

sgd




More information about the thelist mailing list