Hi!
I'm trying to concat two fields together in a database query. I've
read that virtualFields is the way to go with the new versions. The
problem I'm having is that the view doesn't populate the drop down
box. The box has all the fields available, but no text goes with the
fields...it's kind of like "invisible text". What I want to do is
join "division + group" to make it one field.
Here is the part in my model....
---cut---
function _setDivisions() {
$virtualFields = array(
'divandgroup' => 'CONCAT(Division.division, " ",
Division.group)'
);
$divisions = $this->Representative->Division->find
(
'list',
array
(
'fields' => array('id',
$virtualFields['divandgroup']),
'order' => 'Division.division ASC'
)
);
$this->set(compact('divisions'));
}
function add() {
$this->_setDivisions();
if (!empty($this->data)) {
if ($this->Representative->save($this->data)) {
$this->Session->setFlash('Your Representative
has been saved.');
$this->redirect(array('action' => 'index'));
}
}
}
---cut----
Here is what I have in my view
---cut----
echo $form->select(
'Representative.division_id',
$divisions,
null,
array(),
false
);
---cut----
I've tried a number of things and can't seem to get it to work. Any
help would be appreciated!
Thanks!
--
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
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
