Thanks for that. Works perfect!
On Jan 15, 8:24 am, Graham Weldon <[email protected]> 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 <[email protected]>
> wrote:> 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(
>
> > 'OpportunityCategory.id' => '1'
>
> ),
>
> > 'order' => array(
>
> > 'OpportunityCategory.id ASC',
>
> )
>
>
>
> )
> > );
> > $this->set('other_opportunities',
> > $findOtherOpportunities);
>
> > Is there a way to do it using the Model::find function? Or would I
> > have to create a custom SQL within the model?
>
> > Thanks for your help.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
