oracle_asp thread: recordset.absolutepage property not working
What I'm trying to do is to wiew 1 record per page, scrolling the
recordset upwards & downwards. I can't figure out how to do this just with
sql, as the records are not marked in any way that allows to know the next
or previous record of a given one. The only way is to do the full select
every time and then have an 'order' variable that allows to scroll. But
that is very inefficient.
So, if anyone has connected oracle whith IIS and uses the absolutepage
property I would appreciate that he/she would post how to connect, the
drivers used, versions, etc. Thank you!!
and the error message:
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.