> the DEV table on one instance while the datasource 'mydb' is configured to > use the TEST table
Ugh. Long night of tracking down shadows, hints, and allegations. That's the DEV *database* and the TEST *database*, not tables. Turns out the problem was that the previous developer had buried sql queries explicitly stating the database to use in the query: INSERT INTO [DEV].[dbo].[myTable].... -Matthew ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:324302 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
