I agree - it gets pretty convoluted when you add a bit of complexity
into the conditions.
However, I haven't yet come up with a better syntax (aside from
writing plain sql of course).
Have you got any suggestions?
Adam
On Nov 21, 3:23 am, zonium <[EMAIL PROTECTED]> wrote:
> I figured it out:
> The statement should be:
> $count
> =$this->PromoCode->findCount(array('or'=>array(array("PromoCode.start_date"
> =>">
>
> $datetime", 'PromoCode.promo_code'=>$promo_code),
> array('PromoCode.active'=>'<>1'))));
>
> and the result is as expected:
> SELECT COUNT(*) AS `count` FROM `promo_codes` AS `PromoCode` WHERE
> (((`PromoCode`.`start_date` > '2007-11-20 09:11:23') AND
> (`PromoCode`.`promo_code` = 'freemug')) OR (`PromoCode`.`active` <>
> 1))
>
> But ... Too complicated a statement for a simple query. Don't you
> think?
> Thanks!
>
> On Nov 20, 8:55 am, zonium <[EMAIL PROTECTED]> wrote:
>
> > In fact, my select statement was
>
> > $count =$this->PromoCode->findCount(array("PromoCode.start_date" =>">
> > $datetime", 'PromoCode.promo_code'=>$promo_code,
> > "OR"=>array('PromoCode.active'=>'<>1')));
> > and
>
> > Cake created:
> > SELECT COUNT(*) AS `count` FROM `promo_codes` AS `PromoCode` WHERE
> > `PromoCode`.`start_date` > '2007-11-19 08:50:20' AND
> > `PromoCode`.`promo_code` = 'freemug' AND ((`PromoCode`.`active` <> 1))
>
> > I expected
>
> > SELECT COUNT(*) AS `count` FROM `promo_codes` AS `PromoCode` WHERE
> > (`PromoCode`.`start_date` > '2007-11-19 08:50:20' AND
> > `PromoCode`.`promo_code` = 'freemug') OR ((`PromoCode`.`active` <> 1))
>
> > Thanks,
>
> > On Nov 19, 8:42 pm, Grant Cox <[EMAIL PROTECTED]> wrote:
>
> > > Put both conditions in the 'or' key:
>
> > > $datetime = date("Y-m-d H:i:s");
> > > $count
> > > =$this->PromoCode->findCount(array("OR"=>array("PromoCode.start_date"
> > > =>"> $datetime",
>
> > > 'PromoCode.active'=>'<>1')));
>
> > > On Nov 20, 11:49 am, zonium <[EMAIL PROTECTED]> wrote:
>
> > > > I have these statements:
>
> > > > $datetime = date("Y-m-d H:i:s");
> > > > $count =$this->PromoCode->findCount(array("PromoCode.start_date" =>">
> > > > $datetime", "OR"=>array('PromoCode.active'=>'<>1')));
>
> > > > With debug enabled I saw cake tried to create this query:
>
> > > > SELECT COUNT(*) AS `count` FROM `promo_codes` AS `PromoCode` WHERE
> > > > `PromoCode`.`start_date` > '2007-11-19 17:38:54' AND
> > > > ((`PromoCode`.`active` <> 1))
>
> > > > According to the official manual (http://manual.cakephp.org/chapter/
> > > > models) I expected
>
> > > > OR (`PromoCode`.`active` <> 1)
> > > > instead of
> > > > AND ((`PromoCode`.`active` <> 1))
>
> > > > Is it a bug or my statement was not correctly written.
>
> > > > Thanks,
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
