[CDBI] Paging through Results using Class::DBI::Sweet

Bill Moseley moseley at hank.org
Sun Feb 12 14:51:59 GMT 2006

On Sun, Feb 12, 2006 at 07:41:23AM -0500, Dave Mabe wrote:
> How do you loop through the results after you call ->page like in the
> example in the CDBI::Sweet docs?

    perldoc Class::DBI::Iterator
    perldoc Data::Page

> >From the Class::DBI::Sweet docs:
>  __PACKAGE__->set_sql( 'count_by_cd', <<'');
>         SELECT      __ESSENTIAL(me)__, COUNT
> <http://stockcharts.com/def/servlet/SC.web?c=COUNT>(cds.cdid) as
> cd_count
>         FROM <http://stockcharts.com/def/servlet/SC.web?c=FROM>       

What happened there?

Bill Moseley
moseley at hank.org

More information about the ClassDBI mailing list