you should use adoROCOL.cursorlocation=3 before opening the recordset.


-----Original Message-----
From: Bhupendra_Sharma@r... [mailto:Bhupendra_Sharma@r...]
Sent: Saturday, December 07, 2002 10:31 AM
To: ASP Databases
Subject: [asp_databases] RecordCount = -1
Importance: High


I'm having this code in one of my ASP's
set adoROCOL = createobject("adodb.recordset")
adoROCOL.open sqlstr, conn, adOpenStatic, adLockOptimistic
response.write adoROCOL.recordcount
still why is it that i'm getting the result as -1

can somebody please help me
regards