Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle/ADO recordset paging
You could get=et the first 10 rows and fill a structure with the rowids of
those rows. As the person asked for more you would expand the array to
include more rowids. If they want to move backward then you have the rowid
so just retrieve the rows by rowid once you got them.
Jim
Mark Foley wrote in message <7at63u$eb6_at_journal.concentric.net>...
>I am using ASP to interface to an Oracle 7.3.3
>database. I am using the Microsoft ODBC driver for Oracle Version 2
>(2.573.292700).
>
>I want to implement a recordset paging scheme, similar to how
>www.dejanews.com result
>lists work. That is 20 or so records at a time, forward and backward.
>I also want this to be fast, I absolutely can't be doing a full table scan.
>
>How does one implement this sort of thing? The ADO pagesize functionality
>would work, but doesn't seem to with Oracle (it always returns the full
>recordset).
>
>The user can specify several initial SELECT criteria, so I can't really use
>a table column record number where each record has a unique #.
>
>Rownum will limit the # of rows returned, but I need to be able to get
>incremental
>blocks of records (ie. 10-20, then 20-30, then 30-40 etc.)
>
>This seems like something that would be very common, yet everyone seems to
>have trouble with it...
>
>
>
Received on Tue Feb 23 1999 - 07:56:33 CST