Need Help Displaying Search Results

[Charlie65]

If anyone has a solution to this I would be most appreciative.

Problem:
When displaying the results from a record search on an Oracle DB table via a Domino web application it shows all records (ie. 500 or more) all at once. How can I get it to only show a certain number of records per page and a total number of records found?

This is NOT searching from a view, it is searching directly from an Oracle DB on a different server and returning a number of records based on the search (query) criteria. The search works, I just need to know how limit the number of records that are displayed at one time (per page).


Example:
Search for: XXXXX
Total number of records found: 1020
Displaying 1-25 of 1020 Next Previous

 

[AsdaPrice]

You will need to do this with the SQl string the domino is using to get the record set