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
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
