The only difference is that the first is returning an array, which I think is the default from memory. And the second is using the inversejoin which is saying which column to join on, not really used it but the docs can explain that it greater detail
What is your exact problem or question? On Tue, Aug 9, 2011 at 7:29 PM, Glyn Jackson <[email protected]>wrote: > > Can someone tell me the difference between this... > > property name="POIs" fieldtype="many-to-many" fkcolumn="actionID" > cfc="pPOI" type="array" singularname="POI" linktable="pLinkActionsToPOIs"; > > VS.... > > property name="POIs" singularname="POI" fieldtype="many-to-many" cfc="pPOI" > fkcolumn="actionID" inversejoincolumn="poiID" > linktable="pLinkActionsToPOIs"; > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346586 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
