On Tue, 16 Apr 2002 09:26:35 -0500, you wrote: >It may be the ADO connection with Access. I am not sure. DB_adodb is a DB >class I am writing for the Pear_DB abstraction layer. > >I am attaching it to this email so everyone can look at it. At this point it is >kind of a hack. There is no capability in ADO to count the number of records >that a query produced, unless you count each record yourself which would take >too long.
It depends on what kind of recordset cursor you are returning. You're correct on a 'forward ony' recordset, incorrect, for instance, for a static recordset, and possibly correct (or not) for a dynamic recordset. Check the RecordCount property. In some cases, you may have to do a 'movelast' in order to get an accurate count. ADO has the capability; it just doesn't work in all instances. Alan -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
