[Reactor for CF] .join()

[Jeff Lester]

Hi all,

I used to be able to join tables by specifying which column to use as the linking key, things have changed apparently. When I use .join("EventDaysLost","Events","EventID") I now get the error:

The relationship alias EventID does not exist on either EventDaysLost or Events.

Following are the Reactor Relationships that I use between EventDaysLost and Events, what do I need to add to my Reactor.xml to make it work?

        <object name="EventDaysLost">
            <hasOne name="Events">
                <relate from="EventID" to="EventID" />
            </hasOne>
        </object>

        <object name="Events">
            <hasMany name="EventDaysLost" alias="DaysLost">
                <relate from="EventID" to="EventID" />
            </hasMany>
        </object>

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