[CDBI] Re: Help with multiple OR's.

Edward J. Sabol sabol at alderaan.gsfc.nasa.gov
Tue Jul 31 16:52:12 BST 2007

Jeff MacDonald wrote:
> Hi, This is the query I'd like to perform.
> SELECT * FROM foo WHERE enabled = 1 AND (desc = foo or name = foo) AND
> (country = 1 or province = 9)
> I'm trying to build up a $criteria hash to do so.
> The problem I'm running to is the -or under the -and is a hash key and
> of course has to be unique. So I can't make 2..
> Anyone have suggestions ?

You didn't say, but I presume you are asking about
Class::DBI::AbstractSearch. The solution to your problem is to use an
arrayref instead of a hashref. Refer to the SQL::Abstract documentation for
more info:


Hope this helps,

More information about the ClassDBI mailing list