Ahh, so you need the name to be used in an email after the save. In
that case as Zaky says you have the id so do a find and retrieve the
name.
$this->MainModel->State->field('name', array('id'=>$this-
>data['MainModel']['state_id']));
HTH, Paul.
On Aug 22, 4:15 pm, arron <[email protected]> wrote:
> that maybe true but i cant get that to work using the simple mail and
> wizard components. I dont necessarily need it to save to the database
> but just be able to send the name for the state as a email instead of
> a number
>
> On Aug 17, 2:08 am, WebbedIT <[email protected]> wrote:
>
>
>
>
>
>
>
> > I know Irun the risk of preaching to the converted here, but if you
> > have a table of states with IDs and Names then you should only ever
> > save the ID as you never want to save the name more than once. What
> > if you need to change the name of a state (mis-spelling) you then have
> > to run multiple updates to change mulitple occurences rather than
> > changing just the one record in the lookup table.
>
> > It takes no time at all to then reference the state's name once you
> > have the ID as Cake will automatically include any belongsTo
> > associations when running finds on the model and therefore include the
> > state name in $findResult['State']['name']. Maybe you need to go back
> > to whoever is saying you need to store the name and convince them
> > otherwise.
>
> > On Aug 16, 10:04 pm, arron <[email protected]> wrote:
>
> > > I have a dependent drop down
> > > using jquery works fine
>
> > > I found out today that i need to populate the name of the state in
> > > another table instead of the id.
>
> > > in my controller i use a simple find to populate the select box.
>
> > > //controller
>
> > > $states= $this->State->find('list',array
> > > ('fields'=>array('State.id','State.state')));
>
> > > $this->set(compact('states'));
>
> > > in my view when someone picks the state it populates the city
> > > then saves it to my users table state_id
>
> > > //view
>
> > > <?php echo
> > > $this->Form->select('state_id',array($states),'state',array('id'=>'states')
> > > ,false);
>
> > > ?><br /><br /><?php echo $this->Form-
>
> > > >select('city_id',array('name'),'null',array('id'=>'cites'),false);?>
>
> > > the problem i am facing is how can i save the state name instead of
> > > the value ?
>
> > > if i change my controller to this:
>
> > > //controller
>
> > > $states= $this->State->find('list',array
> > > ('fields'=>array('State.state','State.state')));
>
> > > $this->set(compact('states'));
>
> > > It will save the form as i needed it, but my find will not work
> > > because there is no id for the where clause.
>
> > > i just need to save my option instead of my id and cant figure it out
--
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
