u mean this? http://teknoid.wordpress.com/2008/09/04/findlist-with-three-or-combined-fields/
very good article. thx On 17 Set, 13:10, Thiago Nuic Vidigal <[email protected]> wrote: > teknoid has a post on his blog about a "superlist" that does what you want. > > > > On Wed, Sep 16, 2009 at 11:14 AM, santino83 <[email protected]> wrote: > > > Hi, > > > First of all you should use find('first') to get a list from your > > model. As you can read inhttp://book.cakephp.org/view/810/find-list, > > you could set $displayField in Model and tell to cake which field it > > should use as "description". In your case, it seems cake couldn't > > concatenate fields as description, so a solution could be > > > 1) ovveride find in Model class > > 2) using a custom function > > > In both cases, your function will retry all model records, and then > > create a list using some utilities. I use this: > > > $results = $this->find('all', array( 'conditions' => ..., .. .. ) ); > > > /* > > * Extract list, result: model_id => code+description > > */ > > return $results ? array_combine(Set::extract('/MODELNAME/id', > > $results), array_map(array($this,'getDescription'),$results) ) : > > null; > > > and getDescription: > > > private function getDescription($data){ > > return $data['MODELNAME']['code'].' '.$data['MODELNAME'] > > ['description']; > > } > > > note: change MODELNAME rightly > > > On Sep 16, 3:51 pm, Ernesto <[email protected]> wrote: > > > Hello. > > > > i have a model that's using a simple 3-columns table > > > > item_id > > > code > > > description > > > > i want to obtain a select box that shows the fields "code" and > > > "description" concatenated. > > > > right now i'm using a foreach loop > > > > foreach ($items as $key => $item) $selectArray[$key] = $item["code"] . > > > " - " . $item["description"]; > > > > is there any way to do this directly in the "find" call? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
