>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:346587 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm