Hi,
i am developing a web application in java using AS/400 as database, i have to write a sql query which will get only say 20 records from database even if there are 1000 records in the database, and then i can also set that i want records from 21 to 40 and 41 to 60,
I need this to display only 20 records per page .
so how can i do it,

if you use ADODB, use the getstring method or getrows methods in which you can specify how many records to bring at a time and the starting record. So you can do this along in the scroll event of the grid to achieve the purpose.

RV