I'm having a little trouble with a join.
I've read Kevin Roche's post, but unfortuntately, it hasn't helped.
What I have is :
<object name="tblcontacts">
<hasMany name="tblsource">
<link name="tblcontactsource" />
</hasMany>
</object>
<object name="tblcontactsource">
<hasOne name="tblcontacts">
<relate from="ContactID" to="ID" />
</hasOne>
<hasOne name="tblsource">
<relate from="SourceID" to="SourceID" />
</hasOne>
</object>
for my object definitions and
<cfset qContacts.LeftJoin('tblcontacts','tblsource','tblcontactsource')>
in my code.
I've tried all sorts of combinations, but keep getting "object not
found within the query" or "You can not join via a link. Instead join
using each of the steps in the link explicitly".
Does this mean I need to redo my XML? Or is there a way through the
steps in the link that I'm missing?
TIA
Stephen
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
