Hi,
I have an object, "Role" and an object "Rights". Roles and Rights have a
manyToMany relation. I want to associate multiple rights to a role. The
roles and rights are static - only the linking table gets updated to reflect
which rights are associated with a given role.
I figure to do it like this:
(RightsIds = a list of rights that I want to associate to a role)
<cfloop list="#RightsIds#" index="Rightsid">
<!--- adding rights to role nr 1 --->
<cfset role=Transfer.get("Role",1)>
<cfset role.addRights(Transfer.get("Right",Rightsid))>
Transfer.save(role)
</cfloop>
Is this the fastest way or can I do all this in 1 statement?
Btw this is the relevant Transfer.xml snippet
<object name="rights" >
<id name="id" type="numeric" />
<property name="description" type="string" nullable="true" />
<property name="rightKey" type="string" nullable="false" />
<property name="label" type="string" nullable="false" />
<manytomany name="role" table="roleRight" >
<link to="rights" column="FK_right"/>
<link to="role" column="FK_role"/>
<collection type="array">
<order property="label" order="asc" />
</collection>
</manytomany>
</object>
<object name="role">
<id name="id" type="numeric" />
<property name="description" type="string" nullable="true" />
<property name="roleKey" type="string" nullable="false" />
<property name="label" type="string" nullable="false" />
<manytomany name="rights" table="roleRight" lazy="true">
<link to="rights" column="FK_right"/>
<link to="role" column="FK_role"/>
<collection type="array">
<order property="label" order="asc" />
</collection>
</manytomany>
</object>
Marc
--
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
Try out the new Transfer ORM Custom Google Search:
http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8
You received this message because you are subscribed to the Google Groups
"transfer-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/transfer-dev?hl=en
