Re: concatenation in find('list')

This is probably what your looking for...

[controller]
$salespeople = $this->Campaign->Salesperson->find('all',
array('order'=>'Salesperson.firstname ASC', 'fields' =>
'Salesperson.id, Salesperson.firstname, Salesperson.lastname'));
$salespeople = Set::combine($salespeople, '{n}.Salesperson.id',
array('%s %s', '{n}.Salesperson.firstname', 'Salesperson.lastname'));
$this->set('salespeople', $salespeople);

[view]
echo $form->select('Salesperson.id', array($salespeople), null,
array(), '-Please Select-');

On Oct 26, 11:09 am, mario <marioqta...@gmail.com> wrote:
> Hi guys,
>
> I have this following code snippet from my controller:
>
> $salespeople = $this->Campaign->Salesperson->find('list',
>                                   array('order' =>
> 'Salesperson.firstname ASC',
>                                           'fields' =>
> array('Salesperson.id', 'Salesperson.firstname')));
>
> In my view, I have this following line:
>
> echo $form->input('salesperson_id');
>
> This codes would create a combobox in my view
> that would have a key: salesperson.id and value: salesperson.firstname
>
> Now here is what I want to do:
>
> I also have a field 'lastname' under my salespeople table
> and I want it to be concatenated to the salespersons'
> firstname (with a space between the firstname and lastname).
>
> I can't just have the firstname in my combobox because there is
> a high possibility that there would be duplicates for firstnames.
> It would be better if firstname and lastname would be displayed
> in my view's combobox and still would match to a corresponding
> salesperson.id.
>
> Is there a way to do this?
>
> Thanks,
> Mario
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---