>
> Yes you'll have to do this manually as far as I know.
Roger that. Thanks
Dominic
On 03/01/2008, Brian Kotek <[EMAIL PROTECTED]> wrote:
>
> 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/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- --
>
--
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
