• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

11.7. Transaction Processing

ColdFusion provides support for database transaction processing using the CFTRANSACTION tag. The CFTRANSACTION tag lets you treat all query operations with the <CFTRANSACTION> and </CFTRANSACTION> tags as a single transaction. Changes to the database aren't committed until all queries in the transaction have executed successfully. In the event a query within the transaction fails, all previous queries are automatically rolled back. The exception to this occurs when the database itself is changed, as in the case when a table or column is created or deleted.

The CFTRANSACTION tag accepts two optional attributes for controlling how transactions are processed, ACTION and ISOLATION:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint