Re: COM and ADODB access
| From: | Alan Popow | Date: | Tue, 16 Apr 2002 23:44:24 +0000 |
| Subject: | Re: COM and ADODB access | ||
| References: | 1 2 3 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-13131@lists.php.net to get a copy of this message | ||
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