Try this:
$free_applications = $this->Candidate->JobApplication->findAll(array(
"Candidate.id" => $id,
"JobApplication.status" => 1,
"JobApplication.recruitment_id" => "!= IS NOT NULL"
));
On May 16, 9:12 am, flo35 <[EMAIL PROTECTED]> wrote:
> Hi
> i have a problem with FindAll. I want field in the database which
> recruitment_id has the value NULL.
>
> $free_applications =
> $this->Candidate->JobApplication->findAll(array("Candidate.id" => $id,
> "JobApplication.status" => 1,
>
> "JobApplication.recruitment_id" => "<=> NULL"));
>
> The request doesn't return result.
>
> I have also another request that return fields that are not Null. This
> one works.
>
> $rec_applications =
> $this->Candidate->JobApplication->findAll(array("Candidate.id" => $id,
> "JobApplication.status" => 1,
>
> "JobApplication.recruitment_id" => "!= NULL"));
>
> Thanks for your help
>
> flo
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
