Probably something like this:
$this->paginate['conditions'] = array(
'OR' => array (
'User.name' => 'IS NULL',
'Recipe.id' => 'IS NULL'
)
);
On Jul 24, 2:32 am, iFeghali <[email protected]> wrote:
> Hello All,
>
> Say I have a User hasMany Recipes. Now I want to search for all users
> with an empty name OR users that doesn't have any recipe. How do I
> turn that piece of code in what I want:
>
> $this->paginate['conditions'] = array('User.name' => 'IS NULL');
> $this->set('users', $this->paginate());
>
> Can I do that in a single query condition ?
>
> Thank you.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
