MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:James Treworgy Date:September 10 2000 4:31pm
Subject:Re: Problem with RecordCount with ASP & MySQL
View as plain text  
This would be fine for very small result sets, but often you want to know 
how many records you've got before you try to do anything with them.  For 
example, if this was a search engine, the script would certainly fail 
because 1) you're sending your script a result set with a number of records 
potentially as large as the entire table (since MyODBC doesn't support 
cursors), and 2) you're then trying to copy them all into an array in memory.

You will almost certainly want to use SELECT COUNT(*) first to find out the 
result set size, then use a LIMIT clause to select only the records you 
want (e.g. show 20 results at a time), unless the situation is very controlled.

Jamie

At 12:09 PM 9/10/00, Christopher R. Jones wrote:
>recordcount does not work but there is a work around.  Use the GetRows 
>method with an array variant to store the selected rows (JavaScrip 
>example, I don't use VBScript):

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