<CFTRANSACTION ISOLATION="ODBC_lock"> ... </CFTRANSACTION>
Use CFTRANSACTION to group multiple queries into a single unit. CFTRANSACTION can also provide rollback processing.
Optional. ODBC lock type. Valid entries are:
Any queries executed with CFQUERY and placed between <CFTRANSACTION> and </CFTRANSACTION> tags are treated as a single transaction. Changes to data requested by these queries are not committed to the database until all actions within the transaction block have executed successfully. If an error occurs in a query, all changes made by previous queries within the transaction block are rolled back.
Use the ISOLATION attribute for additional control over how the database engine performs locking during the transaction.