[thelist] Number of records returned
Chris Marsh
chris at webbtech.co.uk
Thu Aug 15 10:03:00 CDT 2002
Dear All
I have the following code:
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open Application("strConn")
strSQL = "SELECT *** FROM *** WHERE *** = 1"
Set objRS = objConn.Execute(strSQL)
I know that everything is working as it should, as I am getting the
correct data. However, before I actually start working with the data I
wish to find out how many records were returned. I tried:
objRS.RecordCount
which returned -1, even though I know that there are records there
because I could Response.Write them. Am I missing something fairly
obvious?
TIA
Regards
Chris Marsh
More information about the thelist
mailing list