Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle/ADO recordset paging

Re: Oracle/ADO recordset paging

From: Jim Kennedy <Jim_Kennedy_at_MedicaLogic.com>
Date: Tue, 23 Feb 1999 05:56:33 -0800
Message-ID: <_syA2.41491$202.20156146@news1.teleport.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US