CFTRANSACTION

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

Syntax

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

Optional. The actions are as follows:

  • BEGIN, which indicates the start of the block of code to be executed. It is the default value.

  • COMMIT, which commits a pending transaction.

  • ROLLBACK, which rolls back a pending transaction.

ISOLATION

Optional. ODBC lock type. Valid entries are:

  • Read_Uncommitted

  • Read_Committed

  • Repeatable_Read

  • Serializable

Usage

A transaction block is created within these tags:

 <CFTRANSACTION> queries to be executed ...

Get Sams Teach Yourself ColdFusion® in 21 Days now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial