If the databases are on the same server, you can try accessing the "other" database from your "main" data source by specifying the full path to the table:
SELECT * FROM databaseName.owner.tableName On SQL Server, owner is often "dbo". Or you can use the shortcut databaseName..tableName ~Brad -------- Original Message -------- Subject: cftransaction and multiple databases From: "Chad Gray" <[email protected]> Date: Wed, March 24, 2010 3:05 pm To: cf-talk <[email protected]> Hello, ran into this one today. I have a CFTransaction surrounding some queries that insert data. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:332207 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
