try:
$this->paginate['conditions'] = array(
'OR' => array (
'User.name IS' => 'NULL',
'Recipe.id IS' => ' NULL'
)
);
---------------
$this->paginate['conditions'] = array(
'OR' => array (
'User.name IS' => null,
'Recipe.id IS' => null
)
);
----------------
$this->paginate['conditions'] = array(
'OR' => array (
'User.name' => null,
'Recipe.id' => null
)
);
Jaydeep Dave
On Mon, Jul 27, 2009 at 12:33 PM, byqsri <marco.rizze...@gmail.com> wrote:
>
> It doesnt work.
> The resulted query is :
> `User`.`name` = 'IS NULL'
>
> On 27 Lug, 04:30, "Dr. Loboto" <drlob...@gmail.com> wrote:
> > 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 <igor.fegh...@gmail.com> 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.- Nascondi testo citato
> >
> > - Mostra testo citato -
> >
>
--
Regards,
Jaydeep Dave
Mobile: +919898456445
Email: jaydipd...@yahoo.com
--~--~---------~--~----~------------~-------~--~----~
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+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
