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
>
> > > <option value='field1value'>field2value - field3value</option>"
>
> > >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 [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
-~----------~----~----~----~------~----~------~--~---
