ah thats what you mean
did you try setting $displayField of that model to "name"?
that should also work
On 5 Dez., 19:04, aries <br...@allemana.com> wrote:
> Solution:
>
> In the Regions controller, I have to specify the find fields, viz:
>
> $reporters = $this->Region->Reporter->find('list', array('fields' =>
> array('id', 'name')));
>
> Thanks,
> -Brian
>
> On Dec 5, 11:45 am, aries <br...@allemana.com> wrote:
>
>
>
>
>
>
>
> > Hi there,
>
> > Thanks for your response. I should have clarified my situation. I have
> > a form for a related Region model (HABTM relationship) that calls
> > $this->Form->input('Reporter'); to show a multi select list of
> > Reporter records. I figured that adding a virtual name field called
> > "name" would auto-populate the select list with the reporters' names
> > like it does if the database already contains a field called "name".
> > As it happens, Cake does not auto populate the multi select list this
> > way when a virtual field called "name" is used.
>
> > Is there a way to have Cake display the virtual field as the select
> > menu's option names?
>
> > Thanks,
> > -Brian
>
> > On Dec 3, 3:42 pm, euromark <dereurom...@googlemail.com> wrote:
>
> > > you might be doing sth wrong
> > > how are you processing the result?
>
> > > because Reporter__name is correct so far.
> > > cake will then automatically merge the content of this key back to the
> > > Model result array with the key "name".
> > > and then it should be available with
> > > $result['Reporter']['name']
>
> > > since "name" and "title" have a special meaning (auto-displayField
> > > fields) it might also be related to this.
> > > did you try to use "full_name" as key to eliminate that cause yet?
>
> > > On 3 Dez., 21:21, aries <br...@allemana.com> wrote:
>
> > > > Hello,
>
> > > > I'm trying to use virtual fields with Cake 2.0 and am running into a
> > > > problem. I'm trying to populate a select input with values from a
> > > > table that has no `name` field. I'm setting a virtual field called
> > > > `name` with the first_name and last_name fields, but the menu is not
> > > > populating properly.
>
> > > > In my model I have simply:
>
> > > > public $virtualFields = array(
> > > > 'name' => "CONCAT(Reporter.first_name, ' ',
> > > > Reporter.last_name)"
> > > > );
>
> > > > But when Cake does a find operation, the sql looks like this:
>
> > > > SELECT `Reporter`.`id`, `Reporter`.`first_name`,
> > > > `Reporter`.`last_name`, (CONCAT(`Reporter`.`first_name`, ' ',
> > > > `Reporter`.`last_name`)) AS `Reporter__name`
>
> > > > Calling the field alias `Reporter__name`, which then doesn't register
> > > > with select inputs. Is this expected behavior? Any recommended
> > > > solutions to my problem?
>
> > > > Thanks,
> > > > -Brian
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
