<cftransaction>

Groups multiple queries into a single unit. The cftransaction tag provides commit and rollback processing.

Usage

<cftransaction
    [isolation=string]
    [action=begin|commit|setsavepoint|rollback]
><!--- body ---></cftransaction>

This tag must have a body.

This tag is also supported within cfscript

Attributes

Attribute Description
isolation
(string, optional)

ODBC lock type.

action
(string, optional)
  • begin: The start of the block of code to execute.
  • commit: Commits a pending transaction.
  • rollback: Rolls back a pending transaction.
  • setsavepoint: Saves a specific state within a transaction

Examples

update address set login_address = where id =