On Sat, Mar 14, 2009 at 8:53 AM, kaushik <[email protected]> wrote:
>
> How to use not equal to in condition in finall()?
>
> $data = $this->Blog->findAll(array('Blog.isActive' =>
> 'Y','Blog.blogImage' => ''),array
> ('Blog.blogId','Blog.blogImage','Blog.blogTitle'));
>
> I want to change it so that it finds out blogImage!=''. How to do that?
This should do it:
$data = $this->Blog->find(
'all',
array(
'conditions' => array(
'Blog.isActive' => 'Y',
'Blog.blogImage !=' => ''),
),
'fields' => array(
'Blog.blogId','Blog.blogImage','Blog.blogTitle'
)
)
);
I suggest you use NULL rather than an empty string, though. Also, use
(TINY)INT or BOOLEAN instead of 'Y' & 'N' for boolean columns.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
