wood burning stoves 2.0*
The moose likes JDBC and the fly likes How can a rownum help in implementing Pagination Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How can a rownum help in implementing Pagination " Watch "How can a rownum help in implementing Pagination " New topic
Author

How can a rownum help in implementing Pagination

Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

Hi

How can we use rownum technique to implement pagination .

My query is that we use rownum to limit the the number of records given by database engine .

Where as the concept of Pagination involves to display results based on the click of the Hyper Link
(Similar to Google Search )

For example if i click on "4" Hyperlink i want to display data from 40th record to 50th record , how a rowmnum can help in this case ??

Please share your ideas .

Thanks in advance .






Save India From Corruption - Anna Hazare.
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10266
    
168

There's a journal article for this.

[My Blog] [JavaRanch Journal]
Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

the link is so helpful .

Thank you very much .

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How can a rownum help in implementing Pagination