On 5 Mrz., 08:22, Tom Ptacnik <[email protected]> wrote: > Maybe it's only a typo here, but in relation definition in the Person > table you have "foreign: related" and it should be "foreign: > relatedId" > it's only a simplified example for my problem - so yes a typo but not the problem.
> Or maybe the problem is that if you have M:N relation, you have schema > like this: > > Table1 > ... > relation: > local: id1 > foreign: id2 > ... > > Table2 > ... > relation: > local: id2 > foreign: id1 > > Table12 > .. there is an existing database schema and I can't change the structure because there is a lot of legacy code :-( > > But you have only Table1 and the relation definition has always > local:id1 and never comes to the object where local is id2 - even if > it's a related object... maybe this can couse trables > > In this case the Nest relations can be the solution. > > I don't know, maybe my reflection is bad, or maybe nobody will > uderstand me :-) > > On 3 bře, 20:56,axelat <[email protected]> wrote: > > > I have a list of persons, and an m:n relation that relates one person > > with several other persons: > > > Person: > > columns: > > id > > type: integer(4) > > primary: true > > name: string(255) > > relations: > > # m:n Person2Person > > Person: > > class: Person > > refClass: Person2Person > > local: id > > foreign: related > > foreignAlias: contactPerson > > > # m:n > > Person2Person: > > columns: > > id: > > type: integer(4) > > primary: true > > relatedId: > > type: integer(4) > > primary: true > > relations: > > Person: > > class: Person > > local: relatedId > > foreign: id > > Person2: > > class: Person > > local: id > > foreign: id > > > in the PersonFrom class i use > > $this->embedRelation('RelatedPersons', "myRelatedPersonForm"); > > > everything works fine: > > symfony embedds 1 to n related person forms into the main person form > > also updates work fine > > > the problem ist following: > > each time saving the form symfony commits a query like: > > > update person2person set id = 100 where (id=200 and relatedId=100) > > > (200 is the id of the main form and 100 the "relatedId") > > > and of course this destroys the realation. > > > any idea whats wrong and why this happens? -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com 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
