Re: Creating a "Does not Equal To" SQL Statement

2009-01-15 Thread exo_duz
Thanks for that. Works perfect! On Jan 15, 8:24 am, Graham Weldon wrote: > Hey, > > 'conditions' => array( >    'OpportunityCategory.id !=' => 1) > > That should do it for you. > > Cheers. > > On Thu, 15 Jan 2009 05:13:20 -0800 (PST), exo_duz > wrote:> Hi all, > > > Simple question. I want to c

Re: Creating a "Does not Equal To" SQL Statement

2009-01-15 Thread Graham Weldon
Hey, 'conditions' => array( 'OpportunityCategory.id !=' => 1) That should do it for you. Cheers. On Thu, 15 Jan 2009 05:13:20 -0800 (PST), exo_duz wrote: > Hi all, > > Simple question. I want to create a "Does Not Equal To" SQL statement > within the Controller. The SQL statement would

Creating a "Does not Equal To" SQL Statement

2009-01-15 Thread exo_duz
Hi all, Simple question. I want to create a "Does Not Equal To" SQL statement within the Controller. The SQL statement would just get me back all data when "OpportunityCategory.id" <> 1. $findOtherOpportunities = $this->OpportunityCategory->find('all', array ( 'conditions' => array( 'Opportu