How can I get the recorsdset count as the code loops through the database to find records that meet a certain criteria passed from a form?
get all the rocords then use the count() function in your sql statement or use objRS.Recordcount<BR><BR>But make sure you create your recordset the correct way.....see the VSB scripting reference from micosoft for more info
an example of the syntax for this. Can you help?
One way....<BR><BR>SELECT COUNT(*) FROM myTable WHERE ............<BR><BR><BR>Also, please take a look at http://www.4guysfromrolla.com/webtech/amb/ which answers some common questions