Hi All
I've just upgraded a project to the latest beta 1.2 (cake_1.2.0.6311-
beta) and am struggling to get my head around the new find("list")
syntax.
Previously, I had:
$tags = $this->Output->Tag->generateList(null, array("TagType.name",
"Tag.name ASC"), null, null, null, "{n}.TagType.name");
Which returned me values suitable for a mutliselect box split into
catagories (TagType.name)
I've updated this to use find("list"):
$tags = $this->Output->Tag->find("list",
array("order"=>array("TagType.name", "Tag.name ASC"), null, null,
null, "{n}.TagType.name"));
But this generates the following error:
SQL Error: 1109: Unknown table 'TagType' in order clause
The SQL being generated is:
Query: SELECT `Tag`.`id`, `Tag`.`name` FROM `tags` AS `Tag` WHERE 1 =
1 ORDER BY `TagType`.`name` ASC, `Tag`.`name` ASC
My question is: How to I get find("list") to return the data in the
same structure as my previous generateList() ?
Thanks in advance! :-)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
