Could you create a View in your database that returned ShowId and UserId
(call it ShowUser or whatever), then use this as a link table for a
many-to-many relationship in reactor ?
might work..
Chris
________________________________
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dominic Watson
Sent: 03 January 2008 18:07
To: [email protected]
Subject: [Reactor for CF] Can reactor do my laundry?
Hello there, I've just got Reactor up and running as of last
night and am hugely impressed. Truly awesome work.
The laundry I want doing is as follows. I have four tables:
1. Show, has many productions
2. Production, has one show
3. ProductionUser, has one production
4. User, has many ProductionUsers
I would like to know if I can get Reactor to generate code to
setup the relationship between the User table and the Show table.
At present, I will have to do like this:
productions = user.GetProductionIterator();
while(productions.HasMore()){
show = productions.GetNext().GetShow();
}
And I would like:
shows = user.GetShows();
Is this doable automatically or do I have to add in a custom
method?
Regards,
Dominic
--
Blog it up: http://fusion.dominicwatson.co.uk
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
