[Catalyst] Where has Maypole's pager gone?

Andy Grundman andy at hybridized.org
Thu Apr 28 16:50:09 CEST 2005


Perrin Harkins wrote:
> Andy Grundman said:
> 
>>You could look at my ServerDB example, I implemented a pager with column
>>sorting using CDBI::Pager in about 10 lines of code.
> 
> 
> CDBI::Pager, doesn't use limiting -- it grabs the IDs for the entire
> result set and throws away the ones it doesn't need.  CDBI::Plugin::Pager
> uses LIMIT (or equivalent), but it forces you to use SQL::Abstract for the
> query you want to page, rather than the normal searching.  I'm not sure
> what the Maypole one did.
> 
> LIMIT capabilities should really be part of CDBI.  I usually add them in
> my base class.

I meant to say that I used CDBI::Plugin::Pager. :)

-Andy



More information about the Catalyst mailing list