In that case, a "SELECT Count(*) FROM csvTable" is the best way to go. In fact, this is better than using the rowcount on a client side recordset, because that means the database engine has to parse/read the full recordset in order to get a count.
HTH, Tore. -----Original Message----- From: Tim Fletcher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 9:40 AM To: ActiveServerPages Subject: RE: txt db driver and rs.count i can't have it client side because i need to know before the page is displayed (it is for a progress bar). i've used the old method of manualy counting through the records, not ideal, but it will do :) Thanks for your help HAND Tim -----Message d'origine----- De : Michael Elfial [mailto:[EMAIL PROTECTED]] Envoy� : mercredi 21 ao�t 2002 14:38 � : ActiveServerPages Objet : RE: txt db driver and rs.count Have you tried different options for the recordset ? Something more "client side" may support this (in fact I never used csv driver for something more than just see if it works). -----Original Message----- From: Tim Fletcher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 11:25 AM To: ActiveServerPages Subject: txt db driver and rs.count hi, i can't seem to be able to access the recordset count property if i use a text (csv) db file. is this normal? is there a work around? TIA Tim --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
