What is the behavior of Coldfusion cftransaction tag when multiple databases are accessed?
<p>The coldfusion documentation, (I'm using CF8) states:</p>

<blockquote>
  <p>Changes to data that is requested 
  by the queries are not committed to the datasource until all actions within 
  the transaction block have executed successfully. </p>
</blockquote>

<p>But it also states:</p>

<blockquote>
  <p>In a transaction block, you can write queries to more than one database, but you must commit or roll back a transaction to one database before writing a query to another</p>
</blockquote>

<p>I have multiple transactions in my code base which access 2 databases for both selects and update/inserts. The code assumes that all queries will either succeed or they will all be rolled back. But I don't know if that is true based upon the line in the docs that says: "but you must commit or roll back a transaction to one database before writing a query to another". </p>

<p>What is the behavior if a write to the first database succeeds, then the subsequent write to another database fails? Will the first be rolled back? </p>