[Reactor For CF] Re: Gateways and Joins?

[Brian Kotek]

Never mind all, answered my own question. I realized I could use the gateway to create a Query object, then call the join() method on the Query to set up the join using the relationship defined in the XML, and finally call the gateway using getByQuery() to get back the correct result set.

On 5/2/06, Brian Kotek <[EMAIL PROTECTED]> wrote:

Hi all, here's what I hope is a simple question. Say I have two tables, a teacher table and a person table. Teacher has just two fields, teacherID and personID. So clearly, a teacher maps to a specific person.

Now, what I'd like to do is get back a query of all the teachers with their teacherIDs AND the person's first and last name. So in my Reactor XML I'd have:

<objects>
        <object name="person" />
        <object name="teacher">
            <hasOne name="person">
                <relate from="personID" to="personID" />
            </hasOne>
        </object>
    </objects>


However, a search of the messages, the docs, and dumping the Gateway instance didn't reveal any obvious way to do this. Does the hasOne relationship really only apply to the Record objects and getting related Iterators for a given record, or is there a way to use this relationship as part of a Gateway query? Thanks!

Brian

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