Awesome, thanks. I'll give it a shot, but I'm almost sure this will do it. Cedric
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Blackwell Sent: Monday, February 18, 2008 12:22 PM To: [email protected] Subject: Re: [Reactor for CF] Intermediate table Cedric, Heres an example from one of my apps <object name="Client"> <hasMany name="Note"> <link name="ClientNote" /> </hasMany> </object> <object name="ClientNote"> <hasOne name="Client"> <relate from="ClientId" to="ClientId" /> </hasOne> <hasOne name="Note"> <relate from="NoteId" to="NoteId" /> </hasOne> </object> <object name="Note"> <hasOne name="User" alias="CreatedByUser"> <relate from="CreatedByUserId" to="UserId" /> </hasOne> </object> In the Client object note the use of <link> instead of <relate>. This does exactly what you described, telling reactor that ClientNote is a link table and to create a getNotesIterator() method Cheers, Chris On Feb 18, 2008 7:49 PM, Cedric Villat <[EMAIL PROTECTED]> wrote: > > > > > I have an intermediate lookup table that I need reactor to link together. > > > > For instance, I have 3 tables: Users, Groups, and UserGroups. A group has > many users, and a user can belong to many groups. A sample table would be: > > > > Users: > > UserID User > > 1 me > > 2 you > > > > Groups: > > GroupID Group > > 1 groupA > > 2 groupB > > > > UserGroups: > > UserID GroupID > > 1 1 > > 1 2 > > 2 2 > > > > > > Any idea how the reactor.xml file would set these up? I think when creating > the Users object, I would have to have a hasMany UserGroups. Then my > UserGroups object would have a hasMany Groups. Am I way off base here, or is > there an easier way? Ideally I'd like to be able to do something like > user.getGroups() when I have an instance of my user. > > > > Cedric > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > Reactor for ColdFusion Mailing List > [EMAIL PROTECTED] > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
