Re: Multiple field values in select box?
Excellent! Contrary to my earlier post, http://php-coding-practices.com/ cakephp-specific/how-to-put-combined-fields-into-cakephps-model- generatelist/">myGenerateList does work across Models! Tim Koschützki has really come up with a great one here. Thanks to all who helped me out with this one! Beertigger On Aug 14, 6:34 am, Beertigger <[EMAIL PROTECTED]> wrote: > Not... enough... caffeine... > > Thanks > > On Aug 14, 4:11 am, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > > > Try $listdata[$data['Team']['team']] = $data['Sport']['sport'] . '-' . > > $data['Team']['team']; > > > This missing square bracket you put in the wrong place. > > > Geoff > > > On 8/14/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > > Thanks, Geoff, > > > > I caught that one earlier, also found what I think was a missing ] to > > > close the > > > > $listdata[$data['Team']['team'] = $data['Sport']['sport'] . '-' . > > > $data['Team']['team']; > > > > now: $listdata[$data['Team']['team'] = $data['Sport']['sport'] . '-' . > > > $data['Team']['team']]; > > > > Still no smiles from heaven for this one > > > > Beertigger > > > > On Aug 13, 7:30 pm, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > > > > You've got a error in the getListData function - remove the curly barce > > > > between the end of the query and $listdata = array(); > > > > > Geoff > > > > > On 8/14/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > > > > Found this one earlier. What myGenerateList does, it does very well, > > > > > much easier than using an afterFind to concat things. But, from what I > > > > > can tell thus far, it has the same limitation, in that it can't > > > > > combine data across two models and display it in a third. > > > > > > On Aug 13, 2:58 pm, cdomigan <[EMAIL PROTECTED]> wrote: > > > >http://php-coding-practices.com/cakephp-specific/how-to-put-combined-... > > > > > --http://lemoncake.wordpress.com > > > --http://lemoncake.wordpress.com --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Multiple field values in select box?
Not... enough... caffeine... Thanks On Aug 14, 4:11 am, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > Try $listdata[$data['Team']['team']] = $data['Sport']['sport'] . '-' . > $data['Team']['team']; > > This missing square bracket you put in the wrong place. > > Geoff > > On 8/14/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > > > > > Thanks, Geoff, > > > I caught that one earlier, also found what I think was a missing ] to > > close the > > > $listdata[$data['Team']['team'] = $data['Sport']['sport'] . '-' . > > $data['Team']['team']; > > > now: $listdata[$data['Team']['team'] = $data['Sport']['sport'] . '-' . > > $data['Team']['team']]; > > > Still no smiles from heaven for this one > > > Beertigger > > > On Aug 13, 7:30 pm, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > > > You've got a error in the getListData function - remove the curly barce > > > between the end of the query and $listdata = array(); > > > > Geoff > > > > On 8/14/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > > > Found this one earlier. What myGenerateList does, it does very well, > > > > much easier than using an afterFind to concat things. But, from what I > > > > can tell thus far, it has the same limitation, in that it can't > > > > combine data across two models and display it in a third. > > > > > On Aug 13, 2:58 pm, cdomigan <[EMAIL PROTECTED]> wrote: > > >http://php-coding-practices.com/cakephp-specific/how-to-put-combined-... > > > > --http://lemoncake.wordpress.com > > --http://lemoncake.wordpress.com --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Multiple field values in select box?
Try $listdata[$data['Team']['team']] = $data['Sport']['sport'] . '-' . $data['Team']['team']; This missing square bracket you put in the wrong place. Geoff On 8/14/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > Thanks, Geoff, > > I caught that one earlier, also found what I think was a missing ] to > close the > > $listdata[$data['Team']['team'] = $data['Sport']['sport'] . '-' . > $data['Team']['team']; > > now: $listdata[$data['Team']['team'] = $data['Sport']['sport'] . '-' . > $data['Team']['team']]; > > Still no smiles from heaven for this one > > > Beertigger > > On Aug 13, 7:30 pm, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > > You've got a error in the getListData function - remove the curly barce > > between the end of the query and $listdata = array(); > > > > Geoff > > > > On 8/14/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > > > > > > > Found this one earlier. What myGenerateList does, it does very well, > > > much easier than using an afterFind to concat things. But, from what I > > > can tell thus far, it has the same limitation, in that it can't > > > combine data across two models and display it in a third. > > > > > On Aug 13, 2:58 pm, cdomigan <[EMAIL PROTECTED]> wrote: > > > > > http://php-coding-practices.com/cakephp-specific/how-to-put-combined-... > > > > --http://lemoncake.wordpress.com > > > > > -- http://lemoncake.wordpress.com --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Multiple field values in select box?
Thanks, Geoff, I caught that one earlier, also found what I think was a missing ] to close the $listdata[$data['Team']['team'] = $data['Sport']['sport'] . '-' . $data['Team']['team']; now: $listdata[$data['Team']['team'] = $data['Sport']['sport'] . '-' . $data['Team']['team']]; Still no smiles from heaven for this one Beertigger On Aug 13, 7:30 pm, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > You've got a error in the getListData function - remove the curly barce > between the end of the query and $listdata = array(); > > Geoff > > On 8/14/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > > > Found this one earlier. What myGenerateList does, it does very well, > > much easier than using an afterFind to concat things. But, from what I > > can tell thus far, it has the same limitation, in that it can't > > combine data across two models and display it in a third. > > > On Aug 13, 2:58 pm, cdomigan <[EMAIL PROTECTED]> wrote: > > >http://php-coding-practices.com/cakephp-specific/how-to-put-combined-... > > --http://lemoncake.wordpress.com --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Multiple field values in select box?
You've got a error in the getListData function - remove the curly barce between the end of the query and $listdata = array(); Geoff On 8/14/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > Found this one earlier. What myGenerateList does, it does very well, > much easier than using an afterFind to concat things. But, from what I > can tell thus far, it has the same limitation, in that it can't > combine data across two models and display it in a third. > > > > On Aug 13, 2:58 pm, cdomigan <[EMAIL PROTECTED]> wrote: > > http://php-coding-practices.com/cakephp-specific/how-to-put-combined-... > > > > > -- http://lemoncake.wordpress.com --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Multiple field values in select box?
Found this one earlier. What myGenerateList does, it does very well, much easier than using an afterFind to concat things. But, from what I can tell thus far, it has the same limitation, in that it can't combine data across two models and display it in a third. On Aug 13, 2:58 pm, cdomigan <[EMAIL PROTECTED]> wrote: > http://php-coding-practices.com/cakephp-specific/how-to-put-combined-... --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Multiple field values in select box?
http://php-coding-practices.com/cakephp-specific/how-to-put-combined-fields-into-cakephps-model-generatelist/ --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Multiple field values in select box?
Back at this after a coupla days away - thanks much for all the input. Still having trouble with something entirely too basic. Based on Geoff's last input, here's my current code: In controller: function getListData($data){ $data = $this->Model->query("SELECT Team.team as `Team`,`team` , Team.id as `Team`,`id` , Sport.sport as `Sport`,`sport` FROM `Teams` as Team, `Sports` as Sport, WHERE `Team`.`sport_id` = `Sport`.`id`"); } $listdata = array(); foreach ($data as $item) { $listdata[$data['Team']['team'] = $data['Sport']['sport'] . '-' . $data['Team']['team']; } return $listdata; } In 'add' function: $this->set('listdata', $this->Player->getListData()); In the view: echo $html->selectTag("Player/team", $listdata); I get: With the $listdata = array section: Parse error: syntax error, unexpected T_VARIABLE, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /home/xx/ controllers/players_controller.php on line 371 ($listdata = array) Comment that bit out, and: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getlistdata' at line 1 in /home/x/cake/libs/ model/datasources/dbo_source.php on line 463 On Aug 9, 11:20 pm, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > function getListData($data){ >$data = $this->Model->query("SELECT Model1.field1 as `Model1`,`field1` , > Model1.field2 as `Model1`,`field2` , Model2.field1 as `Model2`,`field1` > FROM `bars` as Model1, `barbars` as Model2, WHERE `Model2`.`barbar_id` = > `Model1`.`id`"); > } > >$listdata = array(); >foreach ($data as $item) { >$listdata[$data['Model1']['field1'] = $data['Model1']['field1'] . '-' > . $data['Model2']['field1']; >} > > return $listdata; > > } > > and later, in the 'add' function: > > $this->set('listdata', $this->Model->getListData()); > > In the view: > > echo $html->selectTag("Player/team", $teamsportlist); > > Not tested but should work. > > Geoff > --http://lemoncake.wordpress.com > > On 8/10/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > > > > > Still trying to concat data from two models into a select list in a > > third. > > > Thanks for the help thus far, Geoff. Taking your advice, and some > > input from IRC, after much trying, I'm at: > > > In controller: > > > function getListData($data){ > > $data = $this->Model->query("SELECT CONCAT(bar, ' - ', barbar) AS > > foobar > > FROM `bars` , `barbars` WHERE `bar`.`barbar_id` = `barbar`.`id`"); > > return $data; > > } > > > $listdata = array(); > > foreach ($data as $item) { > > $listdata[$data]['Model']['foo'] = $data['Model2']['bar'] . > > '-' . > > $data['Model3']['barbar']; > > } > > > and later, in the 'add' function: > > > $this->set('listdata', $this->Model->getListData()); > > > In the view: > > > echo $html->selectTag("Player/team", $teamsportlist, $selectedItems); > > > None of this seems to be working, no matter how I jigger things about. > > Aargh! > > > --Beertigger > > > On Aug 8, 6:59 pm, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > > > All the code I outlined would be in the controller. You could put the > > loop > > > in the getListData() function in the model if you like to keep the > > > controller cleaner. The controller would then just be > > > $this->set('listdata', $this->Model->getListData()); > > > > Geoff > > > > On 8/9/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > > > Somehow, this seems on the right track, but I couldn't get things to > > > > work. Played around with a lot of different variations, but > > > > *something* is not quite kosher, yet. > > > > > Thanks much for the guidance thus far. > > > > > Should the entire > > > > > $data = $this->Model->getListData(); // a function in your model that > > > > does > > > > the custom query to pull the three fields you wnat to use > > > > $mylist = array(); > > > > foreach ($data as $item){ > > > > $mylist[$data['Model']['field1]] = $data['Model']['field2] . '-' . > > > > $data['Model']['field3]; > > > > > } > > > > > be in the Model? > > > > > And the this->set in the controller? > > > > > Sorry for my blatant stupidity. Wrapping what I know of php up with > > > > Cake is proving to be troublesome, at best. The masterbake script > > > > provides such a sweet basic framework that a bit of pain getting > > > > things 'just right' is worth it, but this one thing is really killing > > > > me... ; ) > > > > > On Aug 8, 3:48 pm, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > > > > > OK so use HtmlHelper::select() or selectTag() - I can't remember of > > the > > > > top > > > > > of my head which one it is. My solutions is still the same - creat > > the > > > > > array that you want to display in the list
Re: Multiple field values in select box?
function getListData($data){ $data = $this->Model->query("SELECT Model1.field1 as `Model1`,`field1` , Model1.field2 as `Model1`,`field2` , Model2.field1 as `Model2`,`field1` FROM `bars` as Model1, `barbars` as Model2, WHERE `Model2`.`barbar_id` = `Model1`.`id`"); } $listdata = array(); foreach ($data as $item) { $listdata[$data['Model1']['field1'] = $data['Model1']['field1'] . '-' . $data['Model2']['field1']; } return $listdata; } and later, in the 'add' function: $this->set('listdata', $this->Model->getListData()); In the view: echo $html->selectTag("Player/team", $teamsportlist); Not tested but should work. Geoff -- http://lemoncake.wordpress.com On 8/10/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > Still trying to concat data from two models into a select list in a > third. > > Thanks for the help thus far, Geoff. Taking your advice, and some > input from IRC, after much trying, I'm at: > > In controller: > > function getListData($data){ > $data = $this->Model->query("SELECT CONCAT(bar, ' - ', barbar) AS > foobar > FROM `bars` , `barbars` WHERE `bar`.`barbar_id` = `barbar`.`id`"); > return $data; > } > > $listdata = array(); > foreach ($data as $item) { > $listdata[$data]['Model']['foo'] = $data['Model2']['bar'] . > '-' . > $data['Model3']['barbar']; > } > > and later, in the 'add' function: > > $this->set('listdata', $this->Model->getListData()); > > In the view: > > echo $html->selectTag("Player/team", $teamsportlist, $selectedItems); > > None of this seems to be working, no matter how I jigger things about. > Aargh! > > --Beertigger > > > > On Aug 8, 6:59 pm, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > > All the code I outlined would be in the controller. You could put the > loop > > in the getListData() function in the model if you like to keep the > > controller cleaner. The controller would then just be > > $this->set('listdata', $this->Model->getListData()); > > > > Geoff > > > > On 8/9/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > Somehow, this seems on the right track, but I couldn't get things to > > > work. Played around with a lot of different variations, but > > > *something* is not quite kosher, yet. > > > > > Thanks much for the guidance thus far. > > > > > Should the entire > > > > > $data = $this->Model->getListData(); // a function in your model that > > > does > > > the custom query to pull the three fields you wnat to use > > > $mylist = array(); > > > foreach ($data as $item){ > > > $mylist[$data['Model']['field1]] = $data['Model']['field2] . '-' . > > > $data['Model']['field3]; > > > > > } > > > > > be in the Model? > > > > > And the this->set in the controller? > > > > > Sorry for my blatant stupidity. Wrapping what I know of php up with > > > Cake is proving to be troublesome, at best. The masterbake script > > > provides such a sweet basic framework that a bit of pain getting > > > things 'just right' is worth it, but this one thing is really killing > > > me... ; ) > > > > > On Aug 8, 3:48 pm, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > > > > OK so use HtmlHelper::select() or selectTag() - I can't remember of > the > > > top > > > > of my head which one it is. My solutions is still the same - creat > the > > > > array that you want to display in the listbox manually. > > > > > > Again not sure of the exact array format but something like > > > > > > $data = $this->Model->getListData(); // a function in your model > that > > > does > > > > the custom query to pull the three fields you wnat to use > > > > $mylist = array(); > > > > foreach ($data as $item){ > > > > $mylist[$data['Model']['field1]] = $data['Model']['field2] . '-' . > > > > $data['Model']['field3]; > > > > > > } > > > > > > $this->set("mylist", $mylist); > > > > > > Then in your view something like (again double check the format) > > > > > > $html->select("SelectName", $mylist, $selectedItems); > > > > > > I hope this helps :) > > > > > > Geoff > > > > --http://lemoncake.wordpress.com > > > > > -- http://lemoncake.wordpress.com --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Multiple field values in select box?
Still trying to concat data from two models into a select list in a third. Thanks for the help thus far, Geoff. Taking your advice, and some input from IRC, after much trying, I'm at: In controller: function getListData($data){ $data = $this->Model->query("SELECT CONCAT(bar, ' - ', barbar) AS foobar FROM `bars` , `barbars` WHERE `bar`.`barbar_id` = `barbar`.`id`"); return $data; } $listdata = array(); foreach ($data as $item) { $listdata[$data]['Model']['foo'] = $data['Model2']['bar'] . '-' . $data['Model3']['barbar']; } and later, in the 'add' function: $this->set('listdata', $this->Model->getListData()); In the view: echo $html->selectTag("Player/team", $teamsportlist, $selectedItems); None of this seems to be working, no matter how I jigger things about. Aargh! --Beertigger On Aug 8, 6:59 pm, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > All the code I outlined would be in the controller. You could put the loop > in the getListData() function in the model if you like to keep the > controller cleaner. The controller would then just be > $this->set('listdata', $this->Model->getListData()); > > Geoff > > On 8/9/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > > > > > Somehow, this seems on the right track, but I couldn't get things to > > work. Played around with a lot of different variations, but > > *something* is not quite kosher, yet. > > > Thanks much for the guidance thus far. > > > Should the entire > > > $data = $this->Model->getListData(); // a function in your model that > > does > > the custom query to pull the three fields you wnat to use > > $mylist = array(); > > foreach ($data as $item){ > > $mylist[$data['Model']['field1]] = $data['Model']['field2] . '-' . > > $data['Model']['field3]; > > > } > > > be in the Model? > > > And the this->set in the controller? > > > Sorry for my blatant stupidity. Wrapping what I know of php up with > > Cake is proving to be troublesome, at best. The masterbake script > > provides such a sweet basic framework that a bit of pain getting > > things 'just right' is worth it, but this one thing is really killing > > me... ; ) > > > On Aug 8, 3:48 pm, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > > > OK so use HtmlHelper::select() or selectTag() - I can't remember of the > > top > > > of my head which one it is. My solutions is still the same - creat the > > > array that you want to display in the listbox manually. > > > > Again not sure of the exact array format but something like > > > > $data = $this->Model->getListData(); // a function in your model that > > does > > > the custom query to pull the three fields you wnat to use > > > $mylist = array(); > > > foreach ($data as $item){ > > > $mylist[$data['Model']['field1]] = $data['Model']['field2] . '-' . > > > $data['Model']['field3]; > > > > } > > > > $this->set("mylist", $mylist); > > > > Then in your view something like (again double check the format) > > > > $html->select("SelectName", $mylist, $selectedItems); > > > > I hope this helps :) > > > > Geoff > > --http://lemoncake.wordpress.com --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Multiple field values in select box?
All the code I outlined would be in the controller. You could put the loop in the getListData() function in the model if you like to keep the controller cleaner. The controller would then just be $this->set('listdata', $this->Model->getListData()); Geoff On 8/9/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > Somehow, this seems on the right track, but I couldn't get things to > work. Played around with a lot of different variations, but > *something* is not quite kosher, yet. > > Thanks much for the guidance thus far. > > Should the entire > > $data = $this->Model->getListData(); // a function in your model that > does > the custom query to pull the three fields you wnat to use > $mylist = array(); > foreach ($data as $item){ > $mylist[$data['Model']['field1]] = $data['Model']['field2] . '-' . > $data['Model']['field3]; > > } > > be in the Model? > > And the this->set in the controller? > > Sorry for my blatant stupidity. Wrapping what I know of php up with > Cake is proving to be troublesome, at best. The masterbake script > provides such a sweet basic framework that a bit of pain getting > things 'just right' is worth it, but this one thing is really killing > me... ; ) > > > > On Aug 8, 3:48 pm, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > > OK so use HtmlHelper::select() or selectTag() - I can't remember of the > top > > of my head which one it is. My solutions is still the same - creat the > > array that you want to display in the listbox manually. > > > > Again not sure of the exact array format but something like > > > > $data = $this->Model->getListData(); // a function in your model that > does > > the custom query to pull the three fields you wnat to use > > $mylist = array(); > > foreach ($data as $item){ > > $mylist[$data['Model']['field1]] = $data['Model']['field2] . '-' . > > $data['Model']['field3]; > > > > } > > > > $this->set("mylist", $mylist); > > > > Then in your view something like (again double check the format) > > > > $html->select("SelectName", $mylist, $selectedItems); > > > > I hope this helps :) > > > > Geoff > > > > > > > -- http://lemoncake.wordpress.com --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Multiple field values in select box?
Somehow, this seems on the right track, but I couldn't get things to work. Played around with a lot of different variations, but *something* is not quite kosher, yet. Thanks much for the guidance thus far. Should the entire $data = $this->Model->getListData(); // a function in your model that does the custom query to pull the three fields you wnat to use $mylist = array(); foreach ($data as $item){ $mylist[$data['Model']['field1]] = $data['Model']['field2] . '-' . $data['Model']['field3]; } be in the Model? And the this->set in the controller? Sorry for my blatant stupidity. Wrapping what I know of php up with Cake is proving to be troublesome, at best. The masterbake script provides such a sweet basic framework that a bit of pain getting things 'just right' is worth it, but this one thing is really killing me... ; ) On Aug 8, 3:48 pm, "Geoff Ford" <[EMAIL PROTECTED]> wrote: > OK so use HtmlHelper::select() or selectTag() - I can't remember of the top > of my head which one it is. My solutions is still the same - creat the > array that you want to display in the listbox manually. > > Again not sure of the exact array format but something like > > $data = $this->Model->getListData(); // a function in your model that does > the custom query to pull the three fields you wnat to use > $mylist = array(); > foreach ($data as $item){ > $mylist[$data['Model']['field1]] = $data['Model']['field2] . '-' . > $data['Model']['field3]; > > } > > $this->set("mylist", $mylist); > > Then in your view something like (again double check the format) > > $html->select("SelectName", $mylist, $selectedItems); > > I hope this helps :) > > Geoff > --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Multiple field values in select box?
OK so use HtmlHelper::select() or selectTag() - I can't remember of the top of my head which one it is. My solutions is still the same - creat the array that you want to display in the listbox manually. Again not sure of the exact array format but something like $data = $this->Model->getListData(); // a function in your model that does the custom query to pull the three fields you wnat to use $mylist = array(); foreach ($data as $item){ $mylist[$data['Model']['field1]] = $data['Model']['field2] . '-' . $data['Model']['field3]; } $this->set("mylist", $mylist); Then in your view something like (again double check the format) $html->select("SelectName", $mylist, $selectedItems); I hope this helps :) Geoff On 8/9/07, Beertigger <[EMAIL PROTECTED]> wrote: > > > > Isn't form::select for 1.2? I'm using 1.1 on this project... > > > On Aug 8, 3:05 am, Geoff Ford <[EMAIL PROTECTED]> wrote: > > Forget generateList(). Create the array yourself to pass to > > Form::select() using a custom query if necessary. > > > > Sometimes when you are doing something that is a little bit out of the > > ordinary it can be too hard to make it "Cakeish" and it is easier and > > simpler to do the old php way. :) > > > > Geoff > > --http://lemoncake.wordpress.com > > > > On Aug 8, 4:37 pm, Beertigger <[EMAIL PROTECTED]> wrote: > > > > > I must be far more retarded than the average bear, b/c this is > > > something I just can't get working in Cake. > > > > > I can get the results I want with a basic sql query: > > > > > SELECT CONCAT(team, ' - ', sport) > > > AS teamsport FROM `teams` , `sports` WHERE `teams`.`sport_id` = > > > `sports`.`id` > > > > > when I run it on the db. > > > > > But I can't for the life of me suss out how to frost this up. Should I > > > put the query in the model, or the controller. How do I set things up > > > to use generateList with a findBySql or query? I've searched high and > > > low and high again and can't find any clear-cut code examples for > > > this. > > > > > If you've got the patience to help me out, I will at the least owe you > > > a virtual pint! > > > > > Slainte! > > > > > On Aug 1, 9:51 pm, Beertigger <[EMAIL PROTECTED]> wrote: > > > > > > Anyone? I'm pulling my hair out here. This is something that should > be > > > > basic, shouldn't it? I'll freely admit I'm an idiot, but I'm just > not > > > > understanding this ; ( > > > > > > Thanks to anyone willing to point me in the right direction. > > > > > > On Aug 1, 9:38 am,Beertigger<[EMAIL PROTECTED]> wrote: > > > > > > > Multiple model fields in generatelist... ? > > > > > > > Moving this one along a bit > > > > > I've tried every which way to get this one to work, and I'm > stumped. > > > > > Using afterFind on info from one table works just fine; putting > this > > > > > in the Player model: > > > > > function afterFind($results) { > > > > > foreach ($results as $key => $val) { > > > > > $results[$key]['Player']['fullname'] = > > > > > $val['Player']['fname'] . ' ' . $val['Player']['lname']; > > > > > } > > > > > return $results; > > > > > } > > > > > lets me use 'fullname' in controllers easily enough. > > > > > How do I get something from another table to concat nicely. > > > > > Code like > > > > > function afterFind($results) { > > > > > foreach ($results as $key => $val) { > > > > > $results[$key]['Team']['teamsport'] = > > > > > $val['Team']['team'] . ' ' . $val['Sport']['sport']; > > > > > } > > > > > return $results; > > > > > } > > > > > only gets me the field from the Team table when it's in the Team > > > > > model, and throws a Notice: Undefined index: Sport > in...blahblahblah > > > > > error. > > > > > Team belongsto Sport, Sport hasmany Team > > > > > What kinda hoops do I need to jump threw to get this info in a > Cake-y > > > > > manner? I need to generate a select in another controller. If > > > > > somebody'd hold my hand on this one, it'd be greatly > appreciated... > > > > > Thanks! > > > > > > > On Jul 28, 8:35 am, cauld <[EMAIL PROTECTED]> wrote: > > > > > > > > Not exactly a cake solution, but in the past I've created a > database > > > > > > view an concatenated the two columns I want in the SQL (ex) > > > > > > concat(last_name, ', ', first_name) and then passed the view > results > > > > > > to generateList(). Perhpas you could do the same with query() > and > > > > > > pass those results to generateList(), but I've not tried that > method > > > > > > so can't say it would work, just thinking out loud. Hope that > is > > > > > > helpful. > > > > > > > > On Jul 27, 11:17 pm,Beertigger<[EMAIL PROTECTED]> wrote: > > > > > > > > > Is there any way to get values from multiple fields into a > select box? > > > > > > > > > After much searching, I've come to the conclusion I'm not > going to > > > > > > > find the answer without appealing to those far wiser than > myself... > > > > > > > > > Here's an old thread
Re: Multiple field values in select box?
Isn't form::select for 1.2? I'm using 1.1 on this project... On Aug 8, 3:05 am, Geoff Ford <[EMAIL PROTECTED]> wrote: > Forget generateList(). Create the array yourself to pass to > Form::select() using a custom query if necessary. > > Sometimes when you are doing something that is a little bit out of the > ordinary it can be too hard to make it "Cakeish" and it is easier and > simpler to do the old php way. :) > > Geoff > --http://lemoncake.wordpress.com > > On Aug 8, 4:37 pm, Beertigger <[EMAIL PROTECTED]> wrote: > > > I must be far more retarded than the average bear, b/c this is > > something I just can't get working in Cake. > > > I can get the results I want with a basic sql query: > > > SELECT CONCAT(team, ' - ', sport) > > AS teamsport FROM `teams` , `sports` WHERE `teams`.`sport_id` = > > `sports`.`id` > > > when I run it on the db. > > > But I can't for the life of me suss out how to frost this up. Should I > > put the query in the model, or the controller. How do I set things up > > to use generateList with a findBySql or query? I've searched high and > > low and high again and can't find any clear-cut code examples for > > this. > > > If you've got the patience to help me out, I will at the least owe you > > a virtual pint! > > > Slainte! > > > On Aug 1, 9:51 pm, Beertigger <[EMAIL PROTECTED]> wrote: > > > > Anyone? I'm pulling my hair out here. This is something that should be > > > basic, shouldn't it? I'll freely admit I'm an idiot, but I'm just not > > > understanding this ; ( > > > > Thanks to anyone willing to point me in the right direction. > > > > On Aug 1, 9:38 am,Beertigger<[EMAIL PROTECTED]> wrote: > > > > > Multiple model fields in generatelist... ? > > > > > Moving this one along a bit > > > > I've tried every which way to get this one to work, and I'm stumped. > > > > Using afterFind on info from one table works just fine; putting this > > > > in the Player model: > > > > function afterFind($results) { > > > > foreach ($results as $key => $val) { > > > > $results[$key]['Player']['fullname'] = > > > > $val['Player']['fname'] . ' ' . $val['Player']['lname']; > > > > } > > > > return $results; > > > > } > > > > lets me use 'fullname' in controllers easily enough. > > > > How do I get something from another table to concat nicely. > > > > Code like > > > > function afterFind($results) { > > > > foreach ($results as $key => $val) { > > > > $results[$key]['Team']['teamsport'] = > > > > $val['Team']['team'] . ' ' . $val['Sport']['sport']; > > > > } > > > > return $results; > > > > } > > > > only gets me the field from the Team table when it's in the Team > > > > model, and throws a Notice: Undefined index: Sport in...blahblahblah > > > > error. > > > > Team belongsto Sport, Sport hasmany Team > > > > What kinda hoops do I need to jump threw to get this info in a Cake-y > > > > manner? I need to generate a select in another controller. If > > > > somebody'd hold my hand on this one, it'd be greatly appreciated... > > > > Thanks! > > > > > On Jul 28, 8:35 am, cauld <[EMAIL PROTECTED]> wrote: > > > > > > Not exactly a cake solution, but in the past I've created a database > > > > > view an concatenated the two columns I want in the SQL (ex) > > > > > concat(last_name, ', ', first_name) and then passed the view results > > > > > to generateList(). Perhpas you could do the same with query() and > > > > > pass those results to generateList(), but I've not tried that method > > > > > so can't say it would work, just thinking out loud. Hope that is > > > > > helpful. > > > > > > On Jul 27, 11:17 pm,Beertigger<[EMAIL PROTECTED]> wrote: > > > > > > > Is there any way to get values from multiple fields into a select > > > > > > box? > > > > > > > After much searching, I've come to the conclusion I'm not going to > > > > > > find the answer without appealing to those far wiser than myself... > > > > > > > Here's an old thread for reference, which discusses, w/o resolution, > > > > > > exactly what I'm looking for: > > > > > > > "* Is it possible to use multiple fields to make up the value of the > > > > > > select box? Such that it would come out looking something like > > > > > > > field2value - field3value" > > > > > > >http://groups.google.com/group/cake-php/browse_thread/thread/50a2ecaf... > > > > > > > So, just wondering if anyone ever made any progress on this. Saw the > > > > > > code in trac, but it seems to be for 1.2 (?). Couldn't get it to > > > > > > work, > > > > > > anyway. I'd find this functionality very valuable > > > > > > > Thanks to anyone for any help! --~--~-~--~~~---~--~~ 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:/
Re: Multiple field values in select box?
Form::select is 1.2 only, no? I'm using 1.1 On Aug 8, 3:05 am, Geoff Ford <[EMAIL PROTECTED]> wrote: > Forget generateList(). Create the array yourself to pass to > Form::select() using a custom query if necessary. > > Sometimes when you are doing something that is a little bit out of the > ordinary it can be too hard to make it "Cakeish" and it is easier and > simpler to do the old php way. :) > > Geoff > --http://lemoncake.wordpress.com > > On Aug 8, 4:37 pm, Beertigger <[EMAIL PROTECTED]> wrote: > > > I must be far more retarded than the average bear, b/c this is > > something I just can't get working in Cake. > > > I can get the results I want with a basic sql query: > > > SELECT CONCAT(team, ' - ', sport) > > AS teamsport FROM `teams` , `sports` WHERE `teams`.`sport_id` = > > `sports`.`id` > > > when I run it on the db. > > > But I can't for the life of me suss out how to frost this up. Should I > > put the query in the model, or the controller. How do I set things up > > to use generateList with a findBySql or query? I've searched high and > > low and high again and can't find any clear-cut code examples for > > this. > > > If you've got the patience to help me out, I will at the least owe you > > a virtual pint! > > > Slainte! > > > On Aug 1, 9:51 pm, Beertigger <[EMAIL PROTECTED]> wrote: > > > > Anyone? I'm pulling my hair out here. This is something that should be > > > basic, shouldn't it? I'll freely admit I'm an idiot, but I'm just not > > > understanding this ; ( > > > > Thanks to anyone willing to point me in the right direction. > > > > On Aug 1, 9:38 am,Beertigger<[EMAIL PROTECTED]> wrote: > > > > > Multiple model fields in generatelist... ? > > > > > Moving this one along a bit > > > > I've tried every which way to get this one to work, and I'm stumped. > > > > Using afterFind on info from one table works just fine; putting this > > > > in the Player model: > > > > function afterFind($results) { > > > > foreach ($results as $key => $val) { > > > > $results[$key]['Player']['fullname'] = > > > > $val['Player']['fname'] . ' ' . $val['Player']['lname']; > > > > } > > > > return $results; > > > > } > > > > lets me use 'fullname' in controllers easily enough. > > > > How do I get something from another table to concat nicely. > > > > Code like > > > > function afterFind($results) { > > > > foreach ($results as $key => $val) { > > > > $results[$key]['Team']['teamsport'] = > > > > $val['Team']['team'] . ' ' . $val['Sport']['sport']; > > > > } > > > > return $results; > > > > } > > > > only gets me the field from the Team table when it's in the Team > > > > model, and throws a Notice: Undefined index: Sport in...blahblahblah > > > > error. > > > > Team belongsto Sport, Sport hasmany Team > > > > What kinda hoops do I need to jump threw to get this info in a Cake-y > > > > manner? I need to generate a select in another controller. If > > > > somebody'd hold my hand on this one, it'd be greatly appreciated... > > > > Thanks! > > > > > On Jul 28, 8:35 am, cauld <[EMAIL PROTECTED]> wrote: > > > > > > Not exactly a cake solution, but in the past I've created a database > > > > > view an concatenated the two columns I want in the SQL (ex) > > > > > concat(last_name, ', ', first_name) and then passed the view results > > > > > to generateList(). Perhpas you could do the same with query() and > > > > > pass those results to generateList(), but I've not tried that method > > > > > so can't say it would work, just thinking out loud. Hope that is > > > > > helpful. > > > > > > On Jul 27, 11:17 pm,Beertigger<[EMAIL PROTECTED]> wrote: > > > > > > > Is there any way to get values from multiple fields into a select > > > > > > box? > > > > > > > After much searching, I've come to the conclusion I'm not going to > > > > > > find the answer without appealing to those far wiser than myself... > > > > > > > Here's an old thread for reference, which discusses, w/o resolution, > > > > > > exactly what I'm looking for: > > > > > > > "* Is it possible to use multiple fields to make up the value of the > > > > > > select box? Such that it would come out looking something like > > > > > > > field2value - field3value" > > > > > > >http://groups.google.com/group/cake-php/browse_thread/thread/50a2ecaf... > > > > > > > So, just wondering if anyone ever made any progress on this. Saw the > > > > > > code in trac, but it seems to be for 1.2 (?). Couldn't get it to > > > > > > work, > > > > > > anyway. I'd find this functionality very valuable > > > > > > > Thanks to anyone for any help! --~--~-~--~~~---~--~~ 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/
Re: Multiple field values in select box?
I must be far more retarded than the average bear, b/c this is something I just can't get working in Cake. I can get the results I want with a basic sql query: SELECT CONCAT(team, ' - ', sport) AS teamsport FROM `teams` , `sports` WHERE `teams`.`sport_id` = `sports`.`id` when I run it on the db. But I can't for the life of me suss out how to frost this up. Should I put the query in the model, or the controller. How do I set things up to use generateList with a findBySql or query? I've searched high and low and high again and can't find any clear-cut code examples for this. If you've got the patience to help me out, I will at the least owe you a virtual pint! Slainte! On Aug 1, 9:51 pm, Beertigger <[EMAIL PROTECTED]> wrote: > Anyone? I'm pulling my hair out here. This is something that should be > basic, shouldn't it? I'll freely admit I'm an idiot, but I'm just not > understanding this ; ( > > Thanks to anyone willing to point me in the right direction. > > On Aug 1, 9:38 am,Beertigger<[EMAIL PROTECTED]> wrote: > > > Multiple model fields in generatelist... ? > > > Moving this one along a bit > > I've tried every which way to get this one to work, and I'm stumped. > > Using afterFind on info from one table works just fine; putting this > > in the Player model: > > function afterFind($results) { > > foreach ($results as $key => $val) { > > $results[$key]['Player']['fullname'] = > > $val['Player']['fname'] . ' ' . $val['Player']['lname']; > > } > > return $results; > > } > > lets me use 'fullname' in controllers easily enough. > > How do I get something from another table to concat nicely. > > Code like > > function afterFind($results) { > > foreach ($results as $key => $val) { > > $results[$key]['Team']['teamsport'] = > > $val['Team']['team'] . ' ' . $val['Sport']['sport']; > > } > > return $results; > > } > > only gets me the field from the Team table when it's in the Team > > model, and throws a Notice: Undefined index: Sport in...blahblahblah > > error. > > Team belongsto Sport, Sport hasmany Team > > What kinda hoops do I need to jump threw to get this info in a Cake-y > > manner? I need to generate a select in another controller. If > > somebody'd hold my hand on this one, it'd be greatly appreciated... > > Thanks! > > > On Jul 28, 8:35 am, cauld <[EMAIL PROTECTED]> wrote: > > > > Not exactly a cake solution, but in the past I've created a database > > > view an concatenated the two columns I want in the SQL (ex) > > > concat(last_name, ', ', first_name) and then passed the view results > > > to generateList(). Perhpas you could do the same with query() and > > > pass those results to generateList(), but I've not tried that method > > > so can't say it would work, just thinking out loud. Hope that is > > > helpful. > > > > On Jul 27, 11:17 pm,Beertigger<[EMAIL PROTECTED]> wrote: > > > > > Is there any way to get values from multiple fields into a select box? > > > > > After much searching, I've come to the conclusion I'm not going to > > > > find the answer without appealing to those far wiser than myself... > > > > > Here's an old thread for reference, which discusses, w/o resolution, > > > > exactly what I'm looking for: > > > > > "* Is it possible to use multiple fields to make up the value of the > > > > select box? Such that it would come out looking something like > > > > > field2value - field3value" > > > > >http://groups.google.com/group/cake-php/browse_thread/thread/50a2ecaf... > > > > > So, just wondering if anyone ever made any progress on this. Saw the > > > > code in trac, but it seems to be for 1.2 (?). Couldn't get it to work, > > > > anyway. I'd find this functionality very valuable > > > > > Thanks to anyone for any help! --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Multiple field values in select box?
Anyone? I'm pulling my hair out here. This is something that should be basic, shouldn't it? I'll freely admit I'm an idiot, but I'm just not understanding this ; ( Thanks to anyone willing to point me in the right direction. On Aug 1, 9:38 am, Beertigger <[EMAIL PROTECTED]> wrote: > Multiple model fields in generatelist... ? > > Moving this one along a bit > I've tried every which way to get this one to work, and I'm stumped. > Using afterFind on info from one table works just fine; putting this > in the Player model: > function afterFind($results) { > foreach ($results as $key => $val) { > $results[$key]['Player']['fullname'] = > $val['Player']['fname'] . ' ' . $val['Player']['lname']; > } > return $results; > } > lets me use 'fullname' in controllers easily enough. > How do I get something from another table to concat nicely. > Code like > function afterFind($results) { > foreach ($results as $key => $val) { > $results[$key]['Team']['teamsport'] = > $val['Team']['team'] . ' ' . $val['Sport']['sport']; > } > return $results; > } > only gets me the field from the Team table when it's in the Team > model, and throws a Notice: Undefined index: Sport in...blahblahblah > error. > Team belongsto Sport, Sport hasmany Team > What kinda hoops do I need to jump threw to get this info in a Cake-y > manner? I need to generate a select in another controller. If > somebody'd hold my hand on this one, it'd be greatly appreciated... > Thanks! > > On Jul 28, 8:35 am, cauld <[EMAIL PROTECTED]> wrote: > > > Not exactly a cake solution, but in the past I've created a database > > view an concatenated the two columns I want in the SQL (ex) > > concat(last_name, ', ', first_name) and then passed the view results > > to generateList(). Perhpas you could do the same with query() and > > pass those results to generateList(), but I've not tried that method > > so can't say it would work, just thinking out loud. Hope that is > > helpful. > > > On Jul 27, 11:17 pm,Beertigger<[EMAIL PROTECTED]> wrote: > > > > Is there any way to get values from multiple fields into a select box? > > > > After much searching, I've come to the conclusion I'm not going to > > > find the answer without appealing to those far wiser than myself... > > > > Here's an old thread for reference, which discusses, w/o resolution, > > > exactly what I'm looking for: > > > > "* Is it possible to use multiple fields to make up the value of the > > > select box? Such that it would come out looking something like > > > > field2value - field3value" > > > >http://groups.google.com/group/cake-php/browse_thread/thread/50a2ecaf... > > > > So, just wondering if anyone ever made any progress on this. Saw the > > > code in trac, but it seems to be for 1.2 (?). Couldn't get it to work, > > > anyway. I'd find this functionality very valuable > > > > Thanks to anyone for any help! --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Multiple field values in select box?
Multiple model fields in generatelist... ? Moving this one along a bit I've tried every which way to get this one to work, and I'm stumped. Using afterFind on info from one table works just fine; putting this in the Player model: function afterFind($results) { foreach ($results as $key => $val) { $results[$key]['Player']['fullname'] = $val['Player']['fname'] . ' ' . $val['Player']['lname']; } return $results; } lets me use 'fullname' in controllers easily enough. How do I get something from another table to concat nicely. Code like function afterFind($results) { foreach ($results as $key => $val) { $results[$key]['Team']['teamsport'] = $val['Team']['team'] . ' ' . $val['Sport']['sport']; } return $results; } only gets me the field from the Team table when it's in the Team model, and throws a Notice: Undefined index: Sport in...blahblahblah error. Team belongsto Sport, Sport hasmany Team What kinda hoops do I need to jump threw to get this info in a Cake-y manner? I need to generate a select in another controller. If somebody'd hold my hand on this one, it'd be greatly appreciated... Thanks! On Jul 28, 8:35 am, cauld <[EMAIL PROTECTED]> wrote: > Not exactly a cake solution, but in the past I've created a database > view an concatenated the two columns I want in the SQL (ex) > concat(last_name, ', ', first_name) and then passed the view results > to generateList(). Perhpas you could do the same with query() and > pass those results to generateList(), but I've not tried that method > so can't say it would work, just thinking out loud. Hope that is > helpful. > > On Jul 27, 11:17 pm,Beertigger<[EMAIL PROTECTED]> wrote: > > > Is there any way to get values from multiple fields into a select box? > > > After much searching, I've come to the conclusion I'm not going to > > find the answer without appealing to those far wiser than myself... > > > Here's an old thread for reference, which discusses, w/o resolution, > > exactly what I'm looking for: > > > "* Is it possible to use multiple fields to make up the value of the > > select box? Such that it would come out looking something like > > > field2value - field3value" > > >http://groups.google.com/group/cake-php/browse_thread/thread/50a2ecaf... > > > So, just wondering if anyone ever made any progress on this. Saw the > > code in trac, but it seems to be for 1.2 (?). Couldn't get it to work, > > anyway. I'd find this functionality very valuable > > > Thanks to anyone for any help! --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Multiple model fields in generatelist, was: Multiple field values in select box?
Moving this one along a bit I've tried every which way to get this one to work, and I'm stumped. Using afterFind on info from one table works just fine; putting this in the Player model: function afterFind($results) { foreach ($results as $key => $val) { $results[$key]['Player']['fullname'] = $val['Player']['fname'] . ' ' . $val['Player']['lname']; } return $results; } lets me use 'fullname' in controllers easily enough. How do I get something from another table to concat nicely. Code like function afterFind($results) { foreach ($results as $key => $val) { $results[$key]['Team']['teamsport'] = $val['Team']['team'] . ' ' . $val['Sport']['sport']; } return $results; } only gets me the field from the Team table when it's in the Team model, and throws a Notice: Undefined index: Sport in...blahblahblah error. Team belongsto Sport, Sport hasmany Team What kinda hoops do I need to jump threw to get this info in a Cake-y manner? I need to generate a select in another controller. If somebody'd hold my hand on this one, it'd be greatly appreciated... Thanks! --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Re: Multiple field values in select box?
Not exactly a cake solution, but in the past I've created a database view an concatenated the two columns I want in the SQL (ex) concat(last_name, ', ', first_name) and then passed the view results to generateList(). Perhpas you could do the same with query() and pass those results to generateList(), but I've not tried that method so can't say it would work, just thinking out loud. Hope that is helpful. On Jul 27, 11:17 pm, Beertigger <[EMAIL PROTECTED]> wrote: > Is there any way to get values from multiple fields into a select box? > > After much searching, I've come to the conclusion I'm not going to > find the answer without appealing to those far wiser than myself... > > Here's an old thread for reference, which discusses, w/o resolution, > exactly what I'm looking for: > > "* Is it possible to use multiple fields to make up the value of the > select box? Such that it would come out looking something like > > field2value - field3value" > > http://groups.google.com/group/cake-php/browse_thread/thread/50a2ecaf... > > So, just wondering if anyone ever made any progress on this. Saw the > code in trac, but it seems to be for 1.2 (?). Couldn't get it to work, > anyway. I'd find this functionality very valuable > > Thanks to anyone for any help! --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
Multiple field values in select box?
Is there any way to get values from multiple fields into a select box? After much searching, I've come to the conclusion I'm not going to find the answer without appealing to those far wiser than myself... Here's an old thread for reference, which discusses, w/o resolution, exactly what I'm looking for: "* Is it possible to use multiple fields to make up the value of the select box? Such that it would come out looking something like field2value - field3value" http://groups.google.com/group/cake-php/browse_thread/thread/50a2ecaf2e14f4eb/cc46362244303c7c?lnk=gst&q=%24column+%3D%3E+%24value&rnum=48#cc46362244303c7c So, just wondering if anyone ever made any progress on this. Saw the code in trac, but it seems to be for 1.2 (?). Couldn't get it to work, anyway. I'd find this functionality very valuable Thanks to anyone for any help! --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---