[Reactor for CF] Odd join problem

[Tom McNeer]

Hi,

I have a problem (sometimes) in making more than one join in a query. With certain objects, it works. With others, an error is thrown.

Here's the query code:

<cfset query.join("Insured","PrimaryCoverage","Insured") />
<cfset query.join("PrimaryCoverage","Entities","MCAE") />

And here's the related object code:

<object name="tblPEMS_PrimCovg" alias="PrimaryCoverage" >
            <hasOne name="Insured" alias="insured">
                <relate from="insuredID" to="insuredID"   />
            </hasOne>
            <hasOne name="Entities" alias="MCAE">
                <relate from="entityID" to="entityID" />
            </hasOne>
            <hasOne name="Codes" alias="riskPool">
                <relate from="riskPoolID" to="codeID" />
            </hasOne>
</object>

The first join operates correctly. But when I add the second, I receive:

"The relationship alias MCAE does not exist on either PrimaryCoverage or Entities."

The same sort of error occurs if I try to make the join described in the <hasOne name="Codes" tag above.

On the other hand, I can successfully add a second join to a completely different table (which isn't referenced here).

Anyone know what's happening?


--
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --