Yes you'll have to do this manually as far as I know. You're basically
trying to traverse two relationships, user to production, production to
show. To me this sounds like it would be more efficiently handled as a
custom method in your UserGateway and you can write the SQL yourself (or use
the OO Query syntax if you want to try it, but I find it usually more
trouble than it is worth). So something like userGateway.getShowsForUser
(userID).
On Jan 3, 2008 1:06 PM, Dominic Watson <[EMAIL PROTECTED]>
wrote:
> 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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
