[Catalyst] CDBI/Pager problems

Dylan Vanderhoof DylanV at semaphore.com
Wed Jan 11 02:57:57 CET 2006


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.

Thanks,
Dylan Vanderhoof



More information about the Catalyst mailing list