[CDBI] Help with multiple OR's.

Jeff MacDonald <[email protected]> Tue, 31 Jul 2007 11:44:21 -0400
Newsgroups gmane.comp.lang.perl.modules.class-dbi
Message-ID <[email protected]>
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 ?

Thanks.

----
Jeff MacDonald
Interchange Technologies
613 292 6239