Originally posted by Maria Smith:
But I need all the data in presentaion layer. Only reason I am using pagination is because I can't display all for Ex: 10000 rows on single page and I don't want to go to servlet every time to get next set of data.
Originally posted by Bear Bibeault:
The SQL syntax to do this is different for each DB unfortunately. So you'll need to look it up for your DB.