On Oct 30, 2004, at 8:29 AM, Charlie Boisseau wrote:
Maybe someone can correct me, but it says in the language reference
that MySQL supports the RecordSet.RecordCount function, however when I
try it, it returns -1. According to the language ref this means it's
not supported.
Am I doing something wrong, or is the language ref wrong?
I've reverted to using RecordSet.EOF in a Do...Loop setup instead of
RecordSet.RecordCount in a For loop setup.
Yuck ....
mySQL also has (or had) the nasty behavior that you could not do a
MoveFirst with a recordset
if all you want is the count of records that match some criteria take
you original query and just have it select count(*) using the exact
same where clause etc
That's likely to be a ton faster
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://www.realsoftware.com/listarchives/lists.html>
|