Re: SQL: where column NOT IN ...

Can we add a separate query in the array to not be in?

'not' => array('Model.field' => array( $this->Model-
>find('all', ..)))

will multiple querys work and still associate with the current record
in the find?

example: if i want to display all users who like the color blue, and
therefore are not in a table with a hasMany relationship full of
colors that the user doesnt like, how might i write that?

On Aug 23, 9:04 am, haj <hajim...@gmail.com> wrote:
> On Aug 22, 10:28 pm, Mariano Iglesias <mariano.igles...@cricava.com>
> wrote:
>
> > 'not' => array('Model.field' => array( 1, 2, ...))
>
> That's what I meant; you have to express in that way instead of
> somehow accustomed typical SQL way.

--~--~---------~--~----~------------~-------~--~----~
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 cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---