You need to put the condition in the key, that is:
$conds = array('Node.lft >=' => $node['Node']['lft'], 'Node.rght <='
=> $node['Node']['rght']);
On Apr 10, 6:22 am, 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
-~----------~----~----~----~------~----~------~--~---
