[Reactor For CF] doing lookups to the same table for multiple fields

[Sims, Doug]

Title: doing lookups to the same table for multiple fields

I seem to be getting lost with both the relationships in the XML file and how to access looked up fields when it comes to multiple fields doing lookups to the same table.

I am rewriting a workflow app and am dealing with two main tables (for now).

I have a  table called mrequest that contains a row for each programming request. this table also contains multiple fields that hold ID's that correspond to a userid field in a user table (muser) for fields such as  developer, requestedby, sponsor, etc.
 

table defs:
mrequest: id, int_developer, int_reqforid, reqbyid .......

muser: idn_user ,username .......

So i am getting lost in how to configure the muser object because the muser has many requests  based on role...as developer, the muser "hasmany" requests linked on idn_developer. as requester, the user hasmany as int_reqforid

here is what i have so far:

<objects>
        <object name="mrequest">
                <hasMany name="muser">
                <relate from="int_reqbyid" to="idn_user" alias="reqby" />
                <relate from="int_reqforid" to="idn_user" alias="reqfor" />
                <relate from="int_developer" to="idn_user" alias="developer" />
            </hasMany>       
        </object>
       
        <object name="muser">
            <hasMany name="mrequest">
                <relate from="idn_user" to="id" />
            </hasMany>
        </object>

i can pull the requests i need through the gateway by using getbyfields(intdeveloper=???) but how would i access the lookup values for the fields that are storing a value to lookup by idn_user, i think the answer in that lies in how the relationship is defined in the XML.

What I am trying is not working so, any direction would be appreciated,

Doug

-- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/