[Catalyst] CDBI/Pager problems
Matt S Trout
dbix-class at trout.me.uk
Wed Jan 11 03:37:28 CET 2006
On Tue, Jan 10, 2006 at 05:57:57PM -0800, Dylan Vanderhoof wrote:
> Not sure if this is the right place to ask, but it seems the most likely
> place to get an answer. Trying to figure out some problems with
> CDBI::Plugin::Pager, specifically a complicated where clause.
> I can do things like WHERE foo LIKE 'bar%' OR foo LIKE 'baz%', etc...
> What I'm trying to arrive at is:
> WHERE foo LIKE 'bar%' OR foo LIKE 'baz%' OR (foo LIKE 'bar%' AND foo
> LIKE 'bat%')
> I can't seem to figure out how to get that AND subquery in there. Any
> help would be much appreciated! I've been tinkering with my stupid
> where hash for an hour or so without any appreciable progress.
use base qw/Class::DBI::Sweet/;
or better still DBIx::Class :)
Matt S Trout Offering custom development, consultancy and support
Technical Director contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk for more information
+ Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +
More information about the Catalyst