rs.recordcount always -1! 1

[MikeT]

Even though I can access the information in the recordset, rs.RecordCount always returns a -1. What is going on?

sql = "Select * from

"
set rs = server.CreateObject("adodb.recordset&quot
rs.Open sql, conn 'conn is specified in an include file
Response.Write rs.RecordCount
Response.Write rs("field1&quot 'actually has a value!
rs.close

 

[link9]

thread333-65164

We had a discussion about that a few days ago.

RobV posted a good explanation of why that happens, and how to fix it.

I'll refer you to his explanation

good luck!