this is what I expect
SELECT ...... WHERE `enabled` = 1 AND
((`controller` = 'media' AND `action` = 'index')
OR (`controller` = 'media' AND `action` = '')
OR (`controller` = '' AND `action` = '')) ORDER BY `order`
ASC
On 21 авг, 17:37, clemos <[EMAIL PROTECTED]> wrote:
> Hi
>
> There is no bug, you have:
> $conditions = array(
> "enabled"=>1,
> "or"=>array(
> array("controller"=>"whatever1","action"=>"stuff1"),
> array("controller"=>"whatever2","action"=>"stuff2"),
> ....
> )
> )
>
> So :
> 1. controller = "whatever*" and action="stuff*" are associed by and
> "AND" (default operator)
> 2. all these controller=* AND action=* are put together with operator
> "OR" (because it's the key)
> 3. you add "AND enabled=1" to the whole generated condition, because
> AND is the default operator
>
> What did you expect ?
> Something like that:
> SELECT ...... WHERE `enabled` = 1 OR ((((`controller` = 'media') AND
> (`action` = 'index'))) AND (((`controller` = 'media') AND (`action` =
> ''))) AND (((`controller` = '') AND (`action` = '')))) ORDER BY `order`
> ASC
> ???
>
> ++++++
> Clément
>
>
>
> On Thu, Aug 21, 2008 at 10:53 AM, XuMiX <[EMAIL PROTECTED]> wrote:
>
> > I have a call
> > $conditions = array();
> > $conditions[] = array('controller' => $this-
> >>params['controller'], 'action' => $this->params['action']);
> > $conditions[] = array('controller' => $this-
> >>params['controller'], 'action' => '');
> > $conditions[] = array('controller' => '', 'action' => '');
>
> > $this->blocksData = $model->find('all', array('order' =>
> > 'order ASC',
> > 'conditions'
> > => array('enabled' => '1',
>
> > array('or' => $conditions))));
>
> > here's what i get after call
>
> > SELECT ...... WHERE `enabled` = 1 AND ((((`controller` = 'media') AND
> > (`action` = 'index'))) OR (((`controller` = 'media') AND (`action` =
> > ''))) OR (((`controller` = '') AND (`action` = '')))) ORDER BY `order`
> > ASC
>
> > Is this a bug or my mistake?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
