Oracle/ADO recordset paging

From: Mark Foley <foleym_at_meftechno.com>
Date: 22 Feb 1999 19:08:46 PST
Message-ID: <7at63u$eb6@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 Mon Feb 22 1999 - 21:08:46 CST