cfexit in cftransaction block
According to this Macromedia technote this is what happens when you use cfexit inside a cftransaction block:
When acfexittag is encountered within acftransactionblock of code, the thread in use is released, regardless if themethodattribute is specified. However, because thecftransactionend tag has not been executed yet, the data source name as well as username and password information remains with that thread. Therefore, the next ColdFusion template that runs acfquerywith a different data source name or username/password will cause one of the errors listed above [see below] because it assumes it is still within the samecftransaction.
This results in most of the queries on your server throwing one of the following exceptions:
Datasource names for all the database tags within CFTRANSACTION must be the same.
or
Usernames and Passwords for all the database tags within CFTRANSACTION must be the same.
As far as I know, this only happens for CFMX 6.1

December 26th, 2005 at 1:58 pm
quick Q: do you know if this behaviour remains for CF7?
December 26th, 2005 at 2:08 pm
I haven’t had to use cfexit inside a cftransaction since we upgraded to MX7 so, personnally I don’t know. However, the Macromedia technote states that it is still an issue for MX7.