title: What is the behavior of Coldfusion cftransaction tag when multiple databases are accessed?
body: <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>