On Wed, Mar 24, 2010 at 9:05 PM, Chad Gray wrote: > Datasource FOO verification failed. > The root cause was that: java.sql.SQLException: Datasource names for all the > database tags within the cftransaction tag must be the same. > > How can I get around this error? The function is just doing a select... > there is nothing even to roll back even if the other queries fail.
Run your select from a different thread using cfthread and join it back to the main thread. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:332208 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm