1.

Can We Have More Than Data Source Within Cftransaction?

Answer»

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.

<CFTRANSACTION>
<cfquery datasource=same>
SELECT * FROM TABLENAME
</cfquery>
<cfquery datasource=same>
SELECT * FROM other.dbo.TableName
</cfquery>
</CFTRANSACTION>

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.

<CFTRANSACTION>
<cfquery datasource=same>
SELECT * FROM TableName
</cfquery>
<cfquery datasource=same>
SELECT * FROM other.dbo.TableName
</cfquery>
</CFTRANSACTION>


Discussion

No Comment Found

Related InterviewSolutions