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
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