[Reactor for CF] Second try - Relationship/Join error

[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. And I'll mention
before I go further that I am familiar with the syntax in a join --
FromAlias, ToAlias, RelationshipAlias -- because I've made the mistake
before of putting a field name/alias in place of the relationship alias. But
that's not the problem here.

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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --