Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

Databases: Paging and Hierarchies More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

Data::Page (Score:2, Informative)

by Dom2 (2981) <{dom} {at} {happygiraffe.net}> on 2003.03.31 7:49 (#18519) Homepage Journal

You probably want to investigate Data::Page [cpan.org] and it's cousin Data::PageSet [cpan.org].
I wrote a paging module before. I wouldn't wish the edge cases on anybody.
-Dom

Reply to This
- Re:Data::Page (Score:1)
  
  by Dom2 (2981)
  
  Oooh, I forgot to mention Class::DBI::Pager [cpan.org], which is wizzy if you're using Class::DBI.
  -Dom
- Re:Data::Page (Score:2)
  
  by gnat (29)
  
  Well bollocks. I could have sworn I googled without success for "page database results in perl". So much for being done with Chapter 14! Thanks,
  --Nat
  - Re:Data::Page (Score:1)
    
    by brev (1827)
    
    This is ancient history by now but Tim Bunce supposedly did a review of this, at OSCON in 1999 or 2000? http://www.carumba.com/talk/perl/multiview.shtml IMO paging through RDBMS results is always going to be ugly since SQL is a set-oriented language. You *have* to break the model to do that.

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.