huh. The 1.2 manual was wrong (very possible I missed the
announcement of a change in format). Thanks all!
from 1.2 manual:
array
("Author.name" => "Bob", "or" => array
(
"Post.title" => "LIKE %magic%",
"Post.created" => "> " . date('Y-m-d', strtotime("-2 weeks")
)
)
On Apr 10, 8:51 am, brian <[email protected]> wrote:
> Put the operators on the left side:
>
> 'Node.lft >=' => $node["Node"]["lft"],
>
> On Thu, Apr 9, 2009 at 4: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
-~----------~----~----~----~------~----~------~--~---
