Re: Multiple OR Likes

2007-12-13 Thread AD7six
On Dec 13, 12:20 am, Mr-Yellow <[EMAIL PROTECTED]> wrote: > Was this typed right? > > array( > 'Foo.Cat' => 'LIKE a%', > array( > 'Foo.Cat' => 'LIKE b%' > ), > array( > 'Foo.Cat' => 'LIKE c%' > ) > ); > > They have to be nes

Re: Multiple OR Likes

2007-12-12 Thread Mr-Yellow
Was this typed right? array( 'Foo.Cat' => 'LIKE a%', array( 'Foo.Cat' => 'LIKE b%' ), array( 'Foo.Cat' => 'LIKE c%' ) ); They have to be nested like that or did you mean. array( array( 'Foo.Cat'

Re: Multiple OR Likes

2007-12-12 Thread Mr-Yellow
That's the funny thing, half the examples out there are people telling you to assign the same key with different values, which of course doesn't work. What about multiple OR with ANDs inside? Nested arrays? As for who I've been talking to, there are so many threads on this stuff that it's obviou

Re: Multiple OR Likes

2007-12-11 Thread AD7six
On Dec 12, 7:23 am, Mr-Yellow <[EMAIL PROTECTED]> wrote: > Lets say I want. > > Foo = 1 > AND > Bar = '2' > AND > (Cat LIKE 'a%' OR Cat LIKE 'b%' OR Cat LIKE 'c%') > > Tried just about everything. I am pretty sure you didn't try: $constraint['FooModel.FooField'] = 1; $constraint['BarMo

Multiple OR Likes

2007-12-11 Thread Mr-Yellow
Lets say I want. Foo = 1 AND Bar = '2' AND (Cat LIKE 'a%' OR Cat LIKE 'b%' OR Cat LIKE 'c%') Tried just about everything. How can it be this hard??? Why are there so many users not able to get queries to work in so many situations? Does it mean the overall design of the query construtor