On 9/15/06, SAL VALVERDE <[EMAIL PROTECTED]> wrote:
Hello All,
So, Ive searched the archives of the reactor mailing list, for this
problem. I've found
Hello Sal!
The "relationshipAlias" would be an alias you put on the
relationship. For instance:
<object name="users">
<hasOne name="userGroups" alias="userGroupRelation">
<relate from="userGroup" to="id" />
</hasOne>
</object>
<object name="userGroups">
<hasMany name="permissions" alias="groupPermissionsRelation">
<link name="userGroupPermissions" />
</hasMany>
</object>
And the join command works like "fromTableAlias, toTableAlias, relationAlias".
So I think you want more like:
<cfset q.join("users","userGroups",
"userGroupsRelation").join("userGroups","userGroupPermissions","groupPermissionsRelation")
/>
Something like that. Just a quick mock-up. Hopefully enough to get
you started...
There was a post just a while back about joins, you may want to read
it and see the related blog entry.
Have fun!
:denny
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
