Pagination using jsp and Sybase

[Nila dhan]

I am currently working on pagination using jsp and sybase. Sybase uses set rowcount to n number of records . For instance,

select * from Table_Name set rowcount 10 will return first 10 records from table.

My question is how to get the next set of records for the next page..

Any thoughts, pointers?

Thanks in Advance

[Bear Bibeault]

IS there a way to set an offset?

[Nila dhan]

I am newbie in sybase.. but will check that out..