|
-
Mar 7th, 2004, 07:04 AM
#1
Thread Starter
Addicted Member
ASP 3.0 Cursor Location why ?? {Resolved}
Hi i am trying to set the cursor location of the connection or recordset object,
every time i try i get this error
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/bboard/addins/header.asp, line 11
this is /bboard/addins/header.asp
Code:
<%
dim thers
dim theconn
dim urs
dim sql
dim connstr
set thers = server.createobject("ADODB.RECORDSET")
set theconn = server.createobject("adodb.connection")
set urs = server.createobject("adodb.recordset")
thers.cursorlocation = adUseClient
urs.cursorlocation = adUseClient
connstr = "provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
server.mappath("/BBoard/database/BadgerBoardDB.mdb")
theconn.connectionstring = connstr
theconn.open
%>
according to W3schools you can set this
http://www.w3schools.com/ado/prop_cursorlocation.asp
i am trying to get a recordcount property that is not -1 so if there
is another way please tell
Last edited by señorbadger; Mar 8th, 2004 at 02:07 AM.
-
Mar 7th, 2004, 11:46 PM
#2
Use the number 3 instead of adUseClient.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|