But all the opinions have the same features. Feature -> id , desc 1,Feature 1 ; 2, Feature2...
Opinion shows all the features.. Feature 1 -Score: Feature 2 - Score: OpinionFeature -> opinion_id , feature_id , score I only insert a row here when im scoring a feature. I think my schema is right... no? Thank you very much. 2009/10/1 Abraham Montilla <[email protected]> > elkrema, if you have I have an Opinion with many Features then the right > schema is > > Feature is: id, opinion_id, desc > OpinionFeature is: opinion_id, score > > that's why you have an integrity constraint violation.... I don't know how > i missed that first time i read your post hehe, that's all the problem > > 2009/10/1 elkrema <[email protected]> > > >> With unsetting only option id doesn't work. >> >> The problem is that i am inserting the object of main form and the >> embedded objects too. >> >> But i found a solution... I rewrite the function saveEmbeddedForms in >> OpinionForm >> >> public function saveEmbeddedForms($con = null, $forms = null) >> { >> >> foreach($this->getEmbeddedForms() as $opinionForm) >> { >> >> $opinionForm->getObject()->setOpinionId($this->getObject()->getId >> ()); >> } >> >> >> parent::saveEmbeddedForms($con, $forms); >> } >> >> I set the opinionid before saving the embed forms....I dont know if is >> the good way.. >> >> Otherwise i have a new problem.. >> >> when i'm editing an opinion the value of the last feature is not >> showed.. ¿? >> >> Thank you! >> >> >> >> >> >> >> On 30 sep, 07:21, Abraham Montilla <[email protected]> wrote: >> > try just unsetting opinion_id, tell me if works >> > >> > 2009/9/29 elkrema <[email protected]> >> > >> > >> > >> > >> > >> > > Hello Abraham, >> > >> > > This is my code with i'm embedding forms in OpinionForm: >> > >> > > foreach($this->getObject()->getFeatures() as $feature) >> > > { >> > > $opinionf = new OpinionFeature(); >> > > $opinionf->setOpinionId($this->getObject()->id); >> > > $opinionf->setFeatureId($feature->getId()); >> > > $this->embedForm($feature->getName(), new OpinionFeatureForm >> > > ($opinionf)); >> > > } >> > >> > > With this code in when saving always get this flash message in the >> > > first Feature... >> > >> > > * Feature id: Invalid. >> > >> > > And if i configure OpinionFeatureForm to unset the fields (just for >> > > testing) >> > >> > > unset($this['opinion_id'], $this['feature_id']); >> > >> > > I get .. >> > >> > > SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or >> > > update a child row: a foreign key constraint fails >> > > (`opinion`.`opinion_feature`, CONSTRAINT `opinion_feature_ibfk_1` >> > > FOREIGN KEY (`opinion_id`) REFERENCES `opinion` (`id`) ON DELETE >> > > CASCADE) >> > >> > > Thank you for helping >> > >> > > On 29 sep, 01:25, Abraham Montilla <[email protected]> wrote: >> > > > i think it's because when embedding the OpinionFeatureForms you're >> not >> > > > setting properly the foreign key to the objects, would be something >> like >> > >> > > > for ( $i ..... ){ >> > > > $opfeat = new OpinionFeature(); >> > > > $opfeat->setOpinionId($this->getObject->getId()); >> > > > $OFform = new OpinionFeatureForm($opfeat); >> > > > $this->embedForm('Feature_'.$i, $OFform); >> > >> > > > } >> > >> > > > 2009/9/28 elkrema <[email protected]> >> > >> > > > > Hello >> > >> > > > > i have some problems with my embed forms and i can't find a >> > > > > solution... >> > >> > > > > I have an Opinion with many Features.. >> > >> > > > > Feature is: id, desc >> > > > > OpinionFeature is: opinion_id, feature_id,score >> > >> > > > > In OpinionForm i'm inserting with [for each] all the features, but >> > > > > when im creating a new opinion i always get [Integrity constraint >> > > > > violation] >> > >> > > > > I'ts easy get the id of the feature but i can get the ID of the >> > > > > opinion because it isnt created yet... is null. >> > >> > > > > Somebody can help me please? I get trought many forums and jobeet >> > > > > tutorial but i cant get the solution! >> > >> > > > > PS. Sorry for me english!! >> > >> > > > -- >> > > > Have a nice day. >> > > > Abraham Montilla. >> > >> > -- >> > Have a nice day. >> > Abraham Montilla. >> >> > > > -- > Have a nice day. > Abraham Montilla. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
