In SQL Server, not only can you cross join two databases in a single query, you can join them across separate servers/instances (provided they are linked servers).
-----Original Message----- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: Thursday, March 11, 2010 3:38 PM To: cf-talk Subject: Re: Two CFQUERY statements? On Thu, Mar 11, 2010 at 3:35 PM, Barney Boisvert <bboisv...@gmail.com>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:331640 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
