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:
>
> > 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' => array(
> > array('Report.user_id' => $user_id),
> > array('Report.user_id2' => $user_id)
> > )),
> > array('or'=>array(
> > array('Report.del_flg' => 0),
> > array('Report.status <>' => array('6s', '6r'))
> > ))
> > )
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
