[Catalyst] Looking For Better Way To Handle SQL LEFT JOIN Situation

[Len Jaffe]

> hkclark at gmail.com wrote:
> Is there a way to accomplish what what I want using
> CDBI (or DBIx)? 
> Or is there a way to get "automatic paging via a
> plugin" with
> "Catalyst-Model-DBI" (vs. doing it manually by
> adding my own LIMIT and
> OFFSET to the SELECT along with logic to use it)? 
> Advice and examples
> would be greatly appreciated.

What about the set_sql() method that Class::DBI
inherits from Ima::DBI?  You can defined your LEFT
join so that it can be called via Class::DBI, and so
then you can wrap them in the pager.

Len.

Leonard A. Jaffe     lenjaffe at jaffesystems.com
Leonard Jaffe Computer Systems Consulting Ltd.
Columbus, OH, USA 614-404-4214 F: 530-380-7423