Re: ORM many-to-many code example difference
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 glyn.jack...@newebia.co.ukwrote: 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
Re: ORM many-to-many code example difference
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 glyn.jack...@newebia.co.ukwrote: No issues really. I was just going back in my code I noticed that at some point I started using the inversejoin version for many-to-many i.e. without array. the codes works both ways. I have no idea why I started using one over the other and can see no advantage to either. Does anyone know if one performs better? Thanks ~| 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:346587 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM many-to-many code example difference
It wont be performance as an issue, as each property is how you want to reference the data and what/how it is returned. So if you have a type of array then it will be returned as an array, type of struct returns it as a struct. Not used the inversejoincolumn before so I am assuming that this says I am joining on these IDS from the other side, other than that there is no real differences. On Tue, Aug 9, 2011 at 9:37 PM, Glyn Jackson glyn.jack...@newebia.co.ukwrote: 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 glyn.jack...@newebia.co.uk wrote: No issues really. I was just going back in my code I noticed that at some point I started using the inversejoin version for many-to-many i.e. without array. the codes works both ways. I have no idea why I started using one over the other and can see no advantage to either. Does anyone know if one performs better? Thanks ~| 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:346588 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORM many-to-many code example difference
It wont be performance as an issue, as each property is how you want to reference the data and what/how it is returned. So if you have a type of array then it will be returned as an array, type of struct returns it as a struct. Not used the inversejoincolumn before so I am assuming that this says I am joining on these IDS from the other side, other than that there is no real differences. On Tue, Aug 9, 2011 at 9:37 PM, Glyn Jackson glyn.jack...@newebia.co.ukwrote: Tanks Andrew ;) ~| 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:346589 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
