On Thu, Mar 11, 2010 at 3:35 PM, Barney Boisvert <[email protected]>wrote:
> > You can happily query multiple databases within the same request; what > you can't do is query multiple databases within a single transaction. > So as long as your CFQUERY tags don't share a CFTRANSACTION block you > should be fine. > > Can you post the actual error message? > > cheers, > barneyb > > But you can't do it from within the same <cfquery> tag as they are separate data sources. So you need two queries and then a QoQ to link them together if need be. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331610 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
