Re: Abstract Search question

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

On Wednesday 22 December 2004 02:41 am, Peter Speltz wrote:
> To clarify, i'm talking about being able to write statement like this:
> my @objs = $class->search_where( { A => 'tom',
>                                    B => 'huck',
>                                    C => 'jim' } ,
>                                   { logic => [ 'AND', 'OR'] } );
>  and this would generate the:
> WHERE A = ? and (B = ? or C = ?) .
>
> So every time you need 'logic' you shift one off if size > 1 or use the one

Thanks for the reply Peter! That would be a nice way to express that. I'm 
going to ping the author on this and see what he says.

I was expecting to be able to use the normal syntax where items in a hash are 
and'ed together, and supply a special string for the key of the nested or'ed 
expression. Like this:

{ A => 'tom', NEST => [{B => 'huck'}, {C => 'jim'}] } # NEST is keyword so the 
arrayref isn't interpreted as a modified parameter expression.

Andy