complex select statements and paging

[prev] [thread] [next] [Date index for 2005/01/10]

Hi,

I currently have a problem with combining complex
searches (queries over multiple tables, n-to-n
relations) with CDBI::Plugin::Pager that only can
fetch stuff based on a WHERE statement for a single
table (because it uses SQL::Abstract). I'm at the
point where I don't see a CDBI/SQL::Abstract solution
and am thinking of rolling my own solution of creating
SQL from a perl-datastructure (or extending
SQL::Abstract), and eventually handing this off to
CDBI for object-creation.

Anybody encountered/solved this before? Any
ideas/pointers?

Emile


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Helps protect you from nasty viruses. 
http://promotions.yahoo.com/new_mail