Thanks to both of you for your help. That makes a whole lot of sense.
On May 29, 12:44 pm, AD7six <[EMAIL PROTECTED]> wrote:
> On May 29, 6:40 pm, propellorcut <[EMAIL PROTECTED]> wrote:
>
> > I'm trying to find the number of records returned based on a certain
> > column having the value 11 or 12. I think I'm writing this correctly,
> > but cake doesn't like the fact that I have an OR statement based on 1
> > column.
>
> > this statement:
>
> > $outstanding = $this->Movement-
>
> > >find('count',array('conditions'=>array('OR'=>array('Movement.status'=>11,'Movement.status'=>12)),'recursive'=>-1));
>
> > produces this query:
>
> > SELECT COUNT(*) AS `count` FROM `movements` AS `Movement` WHERE
> > ((`Movement`.`status` = 12))
>
> Not much of a surprise, you are overwriting your array key.
>
> e.g.
> $conditions =
> array('OR'=>array('Movement.status'=>11,'Movement.status'=>12));
> debug ($conditions);
>
> For
> info:http://groups.google.com/group/cake-php/search?group=cake-php&q=array...
>
> in this case:
> find('count',array('conditions'=>array(''Movement.status'=>array(11,
> 12)),'recursive'=>-1));
>
> hth,
>
> AD
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
