Re: Selecting empty rows?

2009-10-17 Thread Marcelo Andrade
On Wed, Oct 14, 2009 at 6:00 PM, BeroFX wrote: > > How can I select records where a column doesn't contain any value, > like ''. > > Doing it like this $this->Document->find('all', array > ('conditions'=>array('Document.title'=>''))); produces a WHERE > `Document`.`title` = NULL query and that's

Re: Selecting empty rows?

2009-10-14 Thread AD7six
On 14 oct, 23:00, BeroFX wrote: > How can I select records where a column doesn't contain any value, > like ''. > > Doing it like this $this->Document->find('all', array > ('conditions'=>array('Document.title'=>''))); produces a WHERE > `Document`.`title` = NULL query and that's not right. are

Re: Selecting empty rows?

2009-10-14 Thread brian
On Wed, Oct 14, 2009 at 5:00 PM, BeroFX wrote: > > How can I select records where a column doesn't contain any value, > like ''. > > Doing it like this $this->Document->find('all', array > ('conditions'=>array('Document.title'=>''))); produces a WHERE > `Document`.`title` = NULL query and that's

Selecting empty rows?

2009-10-14 Thread BeroFX
How can I select records where a column doesn't contain any value, like ''. Doing it like this $this->Document->find('all', array ('conditions'=>array('Document.title'=>''))); produces a WHERE `Document`.`title` = NULL query and that's not right. What I need is a WHERE title='' query returned.