Page by Page module

Tony1 has asked for the wisdom of the Perl Monks concerning the following question:

hi monks, Can any body tell me how to use Data-Page-Set in perl-DBI module. Because i am having a mysql database table which has at about 50,000 record and i wish to display the records as page by page and each page should contain 100 records each. so, i am trying to do this by using Data-Page-Set module in perl-DBI but it's not working or any other way to do it so. i had used limit command. But for me i have to generate a page like as in google like Previous 1 2 3 4 5 6 7 8 9 10 Next Advance thanks!!! by Tony1

Comment on Page by Page module

Replies are listed 'Best First'.
Re: Page by Page module by moritz (Cardinal) on Dec 10, 2007 at 10:17 UTC
You should make the same query as without the paging module, but add a `" limit $limit offset $offset"` to your SQL. There are some examples of paging here in the monastery as well. Use Super Search to find them. If you want some more specific help, you should post the code you've got so far, along with error messages and a description what it should do.	[reply] [d/l]
Re: Page by Page module by Cody Pendant (Prior) on Dec 10, 2007 at 12:03 UTC
You might be getting confused between Data::Pageset and Data::Page::Set which are different modules. The first one looks like what you need. Nobody says perl looks like line-noise any more kids today don't know what line-noise IS ...	[reply]