MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:James Treworgy Date:September 10 2000 3:24pm
Subject:Re: Problem with RecordCount with ASP & MySQL
View as plain text  
... and .MoveLast doesn't work either, because there is no cursor support 
in MyODBC.

Here's the five commandments for those using MyODBC and ADO:

* Thou shalt not update records using rs.Fieldname=x / rs.Update, but using 
SQL statements, e.g. UPDATE ...
* Thou shalt not COUNT records using rs.recordcount, but rather with SQL, 
e.g. SELECT COUNT (*)
* Thou shalt not use any recordset movement methods other than .MoveNext
* Thou shalt not even think about using the paging methods, but rather thou 
shalt use MySQL LIMIT clause in thy SELECT statements to do thy paging.
* Finally, thou shalt not be guaranteed that other wierd things shall not 
happen, but remember that thou can always use SQL to do whatever thou would 
have done with ADO methods/properties.

Finally, if thou breaks these commandments, thou shalt not post a question 
to the MySQL list until thou has searched the archives, or thou risks 
public flogging. ;-)

Jamie

At 09:53 AM 9/10/00, Daniel C BAUFAY wrote:
>Maybe you should issue rs.MoveLast before fetching RecordCount value ?
>Hope this helps.

Thread
Problem with RecordCount with ASP & MySQLAyende Rahien10 Sep
  • Re: Problem with RecordCount with ASP & MySQLJames Treworgy10 Sep
    • Re: Problem with RecordCount with ASP & MySQLChristopher R. Jones10 Sep
      • Re: Problem with RecordCount with ASP & MySQLJames Treworgy10 Sep
Re: Problem with RecordCount with ASP & MySQLDaniel C BAUFAY10 Sep
  • Re: Problem with RecordCount with ASP & MySQLJames Treworgy10 Sep
Re: Problem with RecordCount with ASP & MySQLDaniel C BAUFAY10 Sep
Re: Problem with RecordCount with ASP & MySQLDaniel C BAUFAY10 Sep
Re: Problem with RecordCount with ASP & MySQLDaniel C BAUFAY10 Sep