<CFTRANSACTION 
    ACTION="BEGIN" or "COMMIT" or "ROLLBACK"
    ISOLATION="Read_Uncommitted" or
                 "Read_Committed" or
                 "Repeatable_Read" >
</CFTRANSACTION>

Use CFTRANSACTION to group multiple queries into a single unit. CFTRANSACTION also provides commit and rollback processing. See Usage for details.

ACTION

Optional. The actions are as follows:

ISOLATION

Optional. ODBC lock type. Valid entries are:

Usage

A transaction block is created within these tags:

<CFTRANSACTION>
    queries to be executed
</CFTRANSACTION> 

Within the transaction block, you can commit a transaction by nesting the tag or roll the transaction back by nesting the tag within the block.

Within one transaction block, you can write queries to more than one database; however, you must commit or rollback the transaction to a particular database prior to writing a query to another database.

By using CFML error handling, you have control over whether each transaction is to be committed based on the success or failure of the database query.

Use the ISOLATION attribute for additional control over how the database engine performs locking during the transaction.