Whenever I use ADORecordset RecordCount property I always get -1

MyIronLung · Jul 17, 2001

HELP! I am using a simple query on a standard Microsoft Access sample DB(see code below). It wries out 13 records, but says the recordcount is -1. Why? HELP!

Thanks in advance.
-Chris

<HTML>
<HEAD>
<TITLE>Contact information</TITLE>
</HEAD>
<BODY>

<%
Dim objConn
Dim objRec

Set objConn = Server.CreateObject ("ADODB.Connection&quot

Set objRec = Server.CreateObject ("ADODB.Recordset&quot

objConn.Open "DSN=Contact"

objRec.Open "Contact", objConn, 0, 1 , 2

objRec.MoveFirst

While Not objRec.EOF
Response.Write objRec("Name&quot

& "<BR>"
objRec.MoveNext
Wend

Response.Write (objRec.RecordCount)

objRec.Close
objConn.Close
Set objRec = Nothing
Set objConn = Nothing

%>

</BODY>
</HTML>

vasah20 · Jul 17, 2001

your cursor needs to be set to one that supports backward movement (such as adOpenStatic). see faq333-618 for full information on the the cursors available.

good luck
leo

MyIronLung · Jul 17, 2001

I changed the code to:

objRec.Open "Contact", objConn, adOpenStatic

and it still returns RecordCount = -1

-Chris

vasah20 · Jul 17, 2001

did you include adovbs.inc at the top of your file?

ex:


you need to make sure that you have a copy of the .inc file, though (i think it sits in your windows/winnt directory... i'm not sure...)

MyIronLung · Jul 17, 2001

You da man!

More to the point I'm not da man.

Thanks alot. It works wonderfully now.

-Chris

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Whenever I use ADORecordset RecordCount property I always get -1

MyIronLung

Programmer

vasah20

Programmer

MyIronLung

Programmer

vasah20

Programmer

MyIronLung

Programmer

Similar threads

Part and Inventory Search

Sponsor