Any idea why the Recordset.RecordCount method for ADO does NOT return the correct count ? It always returns the value 1 (unlike Visual Basic which return the total number of records in the table). Here is my scenario:
I have 10 records in a table which are accessed by the following code:
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open DSN, USER, PASSWORD
SQLText = "SELECT Name FROM CustTable"
Set RSName = Server.CreateObject ("ADODB.Recordset")
RSName.Open SQLText, Connection
if RSName.RecordCount = 0 Then
Response.write "No record found"
Perform other processes