I've been hitting a wall concerning this problem for a few days now. In my app I'm trying to generate a report based on a choice chosen from a drop down. The dropdown displays the fields correctly, hides the id and shows the name field(the ID's are correct in the dropdown, I checked). When an option is selected and submit is clicked, it appears as though the ID is changed to just the first number. So if the ID is originally 2044, then it becomes 2, I have no idea why. The view and controller function look right to me. Any ideas?
Controller Function: function report(){
$this->set('alldrugs', $this->Drug->find('list', array(
//'cache' => 'drugList',
//'cacheConfig' => 'sql',
'fields' => array('id', 'generic'),
'order' => 'Drug.generic',
'recursive' => -1,
)));
if (!empty($this->data['Drug'])) { //debug($this->data['Drug']['DrugList']['id']);
$this->Session->setFlash(sprintf($this->data['Drug']['DrugList']['id'])); //$this->redirect(array('controller'=>'drugs','action'=>'generatePatientInfo',$this->data
['Drug']['DrugList']['id']));
}
}
View:<div><?php echo $form->create('Drug');?>
<fieldset>
<legend><?php printf('Calls for Generic Report'); ?></legend>
<?php
echo $form->input('DrugList', array('type' => 'select', 'id' => 'DrugList', 'label' => 'Select generic drug:',
'empty' => 'Select', 'options' => $alldrugs)
);
echo '<br />NOTE: Select a drug above to generate a list of patients who called about it.' .
'<br/>' . 'The report will need to be imported into Excel.';
echo $form->end(__('Submit', true));
?>
</fieldset>
</div>
Locked
