how to query sqlite for certain rows, i.e. dividing it into pages (perl DBI)

Posted by user1380641 on Stack Overflow See other posts from Stack Overflow or by user1380641
Published on 2012-10-22T16:56:58Z Indexed on 2012/10/22 17:00 UTC
Read the original article Hit count: 141

Filed under:
|
|

sorry for my noob question, I'm currently writing a perl web application with sqlite database behind it. I would like to be able to show in my app query results which might get thousands of rows - these should be split in pages - routing should be like /webapp/N - where N is the page number. what is the correct way to query the sqlite db using DBI, in order to fetch only the relavent rows.

for instance, if I show 25 rows per page so I want to query the db for 1-25 rows in the first page, 26-50 in the second page etc....

Thanks in advanced!

© Stack Overflow or respective owner

Related posts about perl

Related posts about sqlite