Abstract Search question

[prev] [thread] [next] [Date index for 2004/12/21]

I've got a question about the SQL::Abstract where format used by 
Class::DBI::AbstractSearch. I hope this isn't too out of place here.

I'm trying to construct a where clause with the following logic: 
 WHERE A = ? and (B = ? or C = ?).

I can't figure out a way to express this, I hope someone here can help. I 
didn't find much discussion on perlmonks or CDBI wiki or CDBI mailing list 
archives. 

The only way I can figure out how to do this horribly abuses the "modified 
operator" mechanism.

use SQL::Abstract;
$sql = new SQL::Abstract;
print $sql->where( { A => 1, '' => [ { 'B =' => 1 }, { 'C =' => 1 } ] } );

It seems like this shouldn't be so hard.

Thanks!
Andy