• Post Reply Bookmark Topic Watch Topic
  • New Topic

Pagination using jsp and Sybase  RSS feed

 
Nila dhan
Ranch Hand
Posts: 161
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Author and ninkuma
Marshal
Posts: 65833
134
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
IS there a way to set an offset?
 
Nila dhan
Ranch Hand
Posts: 161
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am newbie in sybase.. but will check that out..
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!