[thelist] Number of records returned

[Chris Marsh]

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