wrong cursor type??

[chelleybabyger]

i wish to show 5 datas on every page. but i cant seem to do so. below is my codes. the error msg i keep getting is "Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype."
What cursortype should i use then? pls advise.

' Retrieve Orders
sqlString = "SELECT * " &_
"FROM orders, Users, Products, ordereditems " &_
"WHERE order_userID=user_id " &_
"AND ordereditems_orderID=order_id " &_
"AND ordereditems_productID=product_id "

IF showOrders < 99 THEN
sqlString = sqlString & "AND order_status=" & showOrders
END IF
sqlString = sqlString & " ORDER BY order_entrydate DESC"

SET RS = Server.CreateObject( "ADODB.Recordset" )
RS.CursorType = adOpenStatic
IF allPages = "" THEN
RS.PageSize = 5
ELSE
RS.PageSize = 99999
END IF
RS.ActiveConnection = Conn
RS.Open sqlString

IF NOT RS.EOF THEN
RS.AbsolutePage = cINT( showPage )
END IF

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

[Bob Barrows]

Michelle wrote:

i wish to show 5 datas on every page. but i cant seem to do so. below
is my codes. the error msg i keep getting is "Current Recordset does
not support bookmarks. This may be a limitation of the provider or of
the selected cursortype." What cursortype should i use then? pls
advise.

' Retrieve Orders
sqlString = "SELECT * " &_
"FROM orders, Users, Products, ordereditems " &_
"WHERE order_userID=user_id " &_
"AND ordereditems_orderID=order_id " &_
"AND ordereditems_productID=product_id "

IF showOrders < 99 THEN
sqlString = sqlString & "AND order_status=" & showOrders
END IF
sqlString = sqlString & " ORDER BY order_entrydate DESC"

SET RS = Server.CreateObject( "ADODB.Recordset" )
RS.CursorType = adOpenStatic
IF allPages = "" THEN
RS.PageSize = 5
ELSE
RS.PageSize = 99999
END IF
RS.ActiveConnection = Conn
RS.Open sqlString

IF NOT RS.EOF THEN
RS.AbsolutePage = cINT( showPage )
END IF

This should work. What database are you using? And what provider are you
using to connect to it? If you are using ODBC, I suggest switching to a
native OLEDB provider if one is avaliable for your database. See
www.able-consulting.com/ado_conn.htm.

You may need to switch to a client-side cursor. Execute this line before
opening the recordset:
RS.cursorlocation=adUseClient

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[chelleybabyger]

i'm using oracle.
After adding the line u recommended, i another error that says there is an argument conflict..

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

[Bob Barrows [MVP]]

Michelle wrote:

i'm using oracle.
After adding the line u recommended, i another error that says there
is an argument conflict..

Do you have the ADO constants defined? See here:
http://www.aspfaq.com/show.asp?id=2112

The adUseClient constant should contain 3, so, if you don't want to use the
technique in the above article, you can either add this line:
Const adUseClient=3
or change my suggested line to:
RS.cursorlocation=3

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.