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

Do you have

<%
Option Explicit
%>

at the top of your page?

Also:
www.adopenstatic.com/faq/recordcountalternatives.asp
has much better, and faster ways to get a recordcount.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <Bhupendra_Sharma@r...>
Subject: [asp_databases] RecordCount = -1


: 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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

try set adoROCOL = server.createobject("adodb.recordset")



 






 the new MSN 8 and get 2 months FREE*