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