RE: [Reactor for CF] Link relationship modelling question

[Doug Hughes]

So, if I understand you, you want to filter the results in the seatIterator based on criteria from other relationships?    I think I’d handle this by creating a custom method which gets the seatIterator and uses the iterator’s getWhere() method (which is actually an OO query where object) to filter the results.    Doug   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Newby Matthew S CONT PORT Sent: Friday, June 16, 2006 9:30 AM To: 'reactor@reactorframework.com' Subject: [Reactor for CF] Link relationship modelling question   I see from the syntax described in the docs how to relate two tables with a link table in between.  I'm wondering how you go about modelling things when that link includes additional information than just the fact that the two main objects are related...  An example is in order:  In my post about Oracle a couple days ago, I described the user object which hasOne user status, hasMany network accounts, and is linked to user roles.  This same user object is also linked to a seat object, however, there's additional information in the user to seat linking table, such as a date/time stamp indicating when the user was assigned that seat, and a primary flag indicating that this user is the primary user (as opposed to someone who just uses the seat but isn't responsible for the software that's on it).  Is there a way to relate these three tables in Reactor such that the additional information is also available in the iterator, or some other convenient place?  The link tag seems to drop a usable reference to the intermediate table...  Please forgive me if I've missed something obvious in the docs.   Thanks!   -matt     Matthew Newby PNS Web Services PH: 207-438-5263 email: [EMAIL PROTECTED] When digitally signed, the signature is in accordance with DoDI 8520.2, dated 1 Apr 2004.   -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --