How to use ReadBuffer?

[techboss]

I would like to limit the number of records returned by a query and support "paging" through the result set similar to what you would expect on a search engine like..."records 26-50 of 250 displayed" with previous and next buttons. This is for a web application, so I am looking for both CGI and ISAPI solutions. Any examples or code snippets?

TIA,

Anthony

 

[Johan Visser]

To make a query return only the records you want, you want the query to look like this:

select COLUMN from TABLE where rowid in (
select rowid from TABLE where rownum