Tuesday, 23 April 2013

Can we have more than Data Source within CFTransaction? | Coldfusion interview questions

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
   

No comments: