>>is rs.RecordCount as totaly worthless as I think it is or am I just too tired to see straight?
>>
>>I really would prefer NOT to loop through to get a Record Count ...
>>
>>Please forgive any spelling or gramatical errors, its been a very long week. :(
>
>Certain types of ADO cursors do not support the RecordCount property. For example, the default (client side) forward and read only cursor always returns -1 or some other negative number.
>
>Are you using server or client side cursor? I believe static type cursors do return the correct record count.
Like Vin said there needs to be an accounting for this.
Yep, -1. Thats stupid. For performance it should be a property of the rs and it should exist in client side, server side any side.... [Stepping of the soapbox]
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams
