I don't know which version of myODBC you are using but here is a
workaround: try with a COUNT:
rs.Open "Select COUNT(*) from YourTable [WHERE
criteria...]",cnConnectionName
' This will return the total number of rows for the recordset
Records=rs.Fields(0)
Now you have the RecordCount value for your data set.
Regards,
> Did this.
> Doesn't work.
> Apperantely MyODBC doesn't support Recordcount, I don't know why.
>
> ----- Original Message -----
> From: "Daniel C BAUFAY" <pt@stripped>
> To: <Ayende@stripped>
> Cc: <mysql@stripped>
> Sent: Sunday, September 10, 2000 6:05 PM
> Subject: Re: Problem with RecordCount with ASP & MySQL
>
>
>> Maybe you should issue a rs.MoveLast before fetching RecordCount
>> value ? Hope this helps.
>>
>>
>> _________________________________________________________________
>> http://fastmail.ca/ - Fast Free Web Email for Canadians
>
_________________________________________________________________
http://fastmail.ca/ - Fast Free Web Email for Canadians
