Inside Coldfusion MX

<cftransaction action = "begin/commit/rollback" isolation = "read_uncommitted/read_committed/repeatable_read" > queries to execute </cftransaction>

Description

Use this tag when data integrity is essential to the proper execution of your code. This enables the commit and rollback on your database if the transaction is not processed successfully.

Attributes

action (Optional)

Default: begin

• begin. The start of the block of code to execute.

• commit. Commits a pending transaction.

• rollback. Rolls back a pending transaction.

isolation (Optional)

ODBC lock type. Types include read_uncommitted, read_committed, repeatable_read, and serializable.