Try putting the <= and >= operators into the array key as follows:
$sqlConditions = array(
'Node.lft >=' => $node["Node"]["lft"],
'Node.rght <=' => $node["Node"]
["rght"]);
On Apr 9, 10:23 pm, czg <[email protected]> wrote:
> Same thing happens if I replace "generatetreelist" with "findAll"
> -BP
>
> On Apr 9, 3:22 pm, cartosys <[email protected]> wrote:
>
> > my conditions:
>
> > $sqlConditions = array(
> > 'Node.lft' => ">= ".$node["Node"]["lft"],
> > 'Node.rght' => "<= ".$node["Node"]["rght"]);
>
> > $nodes = $this->Node->generateTreeList($sqlConditions);
>
> > and this is the resulting query (from debug level 2):
>
> > SELECT `Node`.`id`, `Node`.`title`, `Node`.`lft`, `Node`.`rght` FROM
> > `nodes` AS `Node` WHERE `Node`.`lft` = '>= 4' AND `Node`.`rght` = '<=
> > 15' ORDER BY `Node`.`lft` asc
>
> > why aren't the comparison operators <= and >= not replacing the =
> > operator?
>
> > -BP
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
