[transfer-dev] Re: HELP!!! Multiple Parents in ManyToMany

2009-01-28 Thread Jorge Loyo 

 so you could create an EntityAward object and have Actor and Director
 each have a onetomany relationship to it.

 Then in EntityAward have a manytoone relation to Award.

Awesome,

Thank you.
--~--~-~--~~~---~--~~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

You received this message because you are subscribed to the Google Groups 
transfer-dev group.
To post to this group, send email to transfer-dev@googlegroups.com
To unsubscribe from this group, send email to 
transfer-dev-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/transfer-dev?hl=en
-~--~~~~--~~--~--~---

[transfer-dev] Re: HELP!!! Multiple Parents in ManyToMany

2009-01-27 Thread Jorge Loyo 

Would this make sense??


package name=award
   object name=award table=tblAward
  id name=awardId type=numeric /
  property name=award type=string column=award /
   /object

   object name=PerformerAward table=tblEntityAward
  compositeid
 manytoone name=Award /
 property name=fk_parent type=numeric column=fk_parent /

 property name=year_awarded type=numeric
column=year_awarded /
  /compositeid
  manytoone name=Award
 link column=fk_award to=award.award/
  /manytoone
   /object

   object name=DirectorAward table=tblEntityAward
  compositeid
 manytoone name=Award /
 property name=fk_parent type=numeric column=fk_parent /

 property name=year_awarded type=numeric
column=year_awarded /
  /compositeid
  manytoone name=Award
 link column=fk_award to=award.award/
 /manytoone
   /object
/package

package name=performer
   object name=performer table=tblPerformer
  id name=performerId type=numeric /
  property name=first_name type=string column=first_name /

  property name=last_name type=string column=last_name /
  onetomany name=Awards
 link to=award.PerformerAward column=fk_parent /
 collection type=array /
  /onetomany
   /object
/package

package name=director
   object name=director table=tblDirector
  id name=directorId type=numeric /
  property name=first_name type=string column=first_name /

  property name=last_name type=string column=last_name /
  onetomany name=Awards
 link to=award.DirectorAward column=fk_parent /
 collection type=array /
  /onetomany
   /object
/package

--~--~-~--~~~---~--~~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

You received this message because you are subscribed to the Google Groups 
transfer-dev group.
To post to this group, send email to transfer-dev@googlegroups.com
To unsubscribe from this group, send email to 
transfer-dev-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/transfer-dev?hl=en
-~--~~~~--~~--~--~---

[transfer-dev] Re: HELP!!! Multiple Parents in ManyToMany

2009-01-27 Thread Sean Coyne 

Not really.

You want something like this (untested since I dont have your DB).

If someone else has a better idea, please chime in.

object name=award table=tblAward
id name=awardid type=numeric /
property name=award type=string /
/object

object name=director table=tblDirector
id name=directorid type=numeric /
property name=name type=string /
manytomany name=Awards table=tblEntityAward
link to=director column=fk_parent/
link to=award column=fk_award/
collection type=array
order property=year_awarded order=asc/
/collection
/manytomany
/object

object name=actor table=tblActor
id name=actorid type=numeric /
property name=name type=string /
manytomany name=Awards table=tblEntityAward
link to=actor column=fk_parent/
link to=award column=fk_award/
collection type=array
order property=year_awarded order=asc/
/collection
/manytomany
/object


On Jan 27, 2:30 pm, Jorge Loyo jorgel...@gmail.com wrote:
 Would this make sense??

--~--~-~--~~~---~--~~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

You received this message because you are subscribed to the Google Groups 
transfer-dev group.
To post to this group, send email to transfer-dev@googlegroups.com
To unsubscribe from this group, send email to 
transfer-dev-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/transfer-dev?hl=en
-~--~~~~--~~--~--~---

[transfer-dev] Re: HELP!!! Multiple Parents in ManyToMany

2009-01-27 Thread Jorge Loyo 

Thank you Sean,

I noticed that you didn't declare the association table, even when
there is a composite key. And you use the year_awarded to order by
array by.

How do you display the year_awarded? Is it included in the collection?


--~--~-~--~~~---~--~~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

You received this message because you are subscribed to the Google Groups 
transfer-dev group.
To post to this group, send email to transfer-dev@googlegroups.com
To unsubscribe from this group, send email to 
transfer-dev-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/transfer-dev?hl=en
-~--~~~~--~~--~--~---