[Catalyst] CDBI/Pager problems
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
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.
More information about the Catalyst