Hi, I'm doing my first PHP/symfony project and I've spent quite a bit
of time reading all of the documentation. I have just created a user
registration page, and in it I am encountering an issue regarding how
to deal with form fields that originate from the database, but which
are not saved to the database.
I have select widgets which have US state names and Canadian province
names, respectively. The correct widget is displayed according to the
country selected by the user in the UI. In turn, I have a
state_prov_id field in my AddressForm, which actually holds the
reference to the correct province or state's ID.
I originally implemented the configure method of my AddressForm as
follows:
<code>
public function configure()
{
// Select only provinces
$provinceCriteria = new Criteria();
$provinceCriteria->addJoin(RefStateProvPeer::COUNTRY_ID,
RefCountryPeer::ID);
$provinceCriteria->add(RefCountryPeer::ISO_VALUE, 'CA',
Criteria::EQUAL);
// Select only states
$stateCriteria = new Criteria();
$stateCriteria->addJoin(RefStateProvPeer::COUNTRY_ID,
RefCountryPeer::ID);
$stateCriteria->add(RefCountryPeer::ISO_VALUE, 'US',
Criteria::EQUAL);
$this->widgetSchema['province'] = new sfWidgetFormPropelChoice
(array('model' => 'RefStateProv', 'add_empty' => 'Please select one',
'criteria' => $provinceCriteria),array('onchange' => 'setSubCountry
(this.value)' ));
$this->widgetSchema['state'] = new sfWidgetFormPropelChoice(array
('model' => 'RefStateProv', 'add_empty' => 'Please select one',
'criteria' => $stateCriteria), array('onchange' => 'setSubCountry
(this.value)'));
</code>
But when I try to save the form, I get a propel error saying that
state and province are not fields in the database.
What is the best way to deal with this? The alternatives which come
to mind are:
1) Put the fields in a different form, which is not a propel form
2) Modify the save method or the updateObject method to exclude these
two fields somehow
Your help is greatly appreciated.
Thanks,
Steve
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
