[Catalyst] CDBI/Pager problems

[Matt S Trout]

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/ +