| Using bookmarks for html/asp re Oracle 8.0.5 [message #77158] |
Thu, 30 September 2004 12:34  |
Nancy Campbell
Messages: 2
Registered: January 2004
|
Junior Member |
|
|
Can you use bookmarks in asp/html when referencing Oracle 8.0.5?
I found an article on the web in reference to bookmarks but it
refers to Oracle 8i. http://www.orafaq.com/faqoo4o.htm#INST
I've tried creating a bookmark on one of
our intranet web pages, however it comes back with this error:
" ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a
limitation of the provider or of the selected cursortype. "
This is the code I am using...
set ors = server.createobject("ADODB.recordset")
ors.Cursortype = adopenstatic
ors.open strSQLquery,connection
[<]%do until ors.eof
mybookmark = ors.bookmark
%[>]
All I need to know is, is this a limitation of the Oracle version 8.0.5?
Thanks!
|
|
|
|
|
|
| Re: Using bookmarks for html/asp re Oracle 8.0.5 [message #77290 is a reply to message #77224] |
Mon, 14 February 2005 17:35  |
Wayne John
Messages: 1
Registered: February 2005
|
Junior Member |
|
|
I am also interested in knowing if this is an issue. I'm currently in redo mode for one of our existing search pages. I'm using Intermedia as well so I'm not sure if that plays into this at all.
I've tried using the CursorLocation property setting from the recordset object to the connection object, and vice versa. On them by themselves, etc...as well as most possible logical combinations of LockType and CursorTypes...
Anyway, here is my code for this:
var cn = Server.CreateObject("ADODB.Connection");
var oRS = Server.CreateObject("ADODB.recordset");
cn.CursorLocation = 2;
oRS.CursorType = 3; //adOpenStatic;
oRS.PageSize = lstResults;
oRS.CursorLocation = 2; //adUseClient
//oRS.LockType = 3; //adLockOptimistic
cn.Open("DSN=Dev2; UserID=nuh-uh; pwd=hey1its2a3password4alrighty");
oRS.Open(strSQL, cn); //<--Fails here
oRS.AbsolutePage = parseInt(thisPage);
Ultimately, I hope to be able to pop an AbsolutePage value on that there recordset. :)
Anyone experience this and happen to overcome it?
Thanks in advance!
Wayne
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
