http://groups.google.com/group/cake-php/browse_thread/thread/996efa1f92415163/6c38e322189ec4ef?lnk=gst&q=manish#6c38e322189ec4ef
On Jan 22, 4:20 pm, RichardAtHome <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---