No.Datasource Names For All The Database Tags Within CFTRANSACTION Must Be The Same.
The workaround for the problem of CFTRANSACTION with different data source,
Use same datasource in CFQUERY
but inside the cfquery prefix the table with desired database in the query.
datasource=same>
SELECT * FROM TableName
datasource=same>
SELECT * FROM other.dbo.TableName
The workaround for the problem of CFTRANSACTION with different data source,
Use same datasource in CFQUERY
but inside the cfquery prefix the table with desired database in the query.
datasource=same>
SELECT * FROM TableName
datasource=same>
SELECT * FROM other.dbo.TableName
No comments:
Post a Comment