Re: nested condition

2008-08-31 Thread haj
yeah, i figured out that later. Only, NOT sth IN ('a', 'b') was kinda unnatural to me in the mind of SQL, i was used to sth NOT IN('a','b') way. On Aug 30, 9:11 pm, Rafael Bandeira aka rafaelbandeira3 [EMAIL PROTECTED] wrote: Only, unfortunately, I found out cake can't yeild expression like:

Re: nested condition

2008-08-30 Thread Rafael Bandeira aka rafaelbandeira3
Only, unfortunately, I found out cake can't yeild expression like: sth NOT IN('a','b') Yes it can, use 'not' = array('sth' = array('a', 'b')) And you could write those conditions like this 'conditions'=array( array( 'or'