[Reactor For CF] Gateways and Joins?

[Brian Kotek]

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/