RecordCount in aspVBScript page

[Steve Conway]

Hello all,

I have a recordset in an asp page

snippet
Set Search = Server.CreateObject("ADODB.Recordset")
etc.
etc.

The recordset is working fine, the page displays the correct results. I am
just trying to include a "n Records Found" display using:
<%
iRecordCount = Search.RecordCount
%>

but Search.RecordCount always has a value of -1 whether there are 10 records
or no records. Therefore, my 'Records Found' always shows -1. Am I missing
something regarding .RecordCount

Thanks
Steve C

 

[Stefan B Rusynko]

See http://www.aspfaq.com/show.asp?id=2193

 

[Steve Conway]

Thanks Stefan, that was the issue. Using the GetRows() solution works just
fine

Steve C