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

Chapter 14.  Handling Errors and Exce... >  Using the <cftransaction> Tag

Using the <cftransaction> Tag

In spite of handling errors at all layers, the bug might still appear at the database level. As a result, the database might crash or the query may not execute. The <cftransaction> tag protects database integrity and adds a final layer of error handling. This tag brings your database to its original condition if an operation fails. <cftransaction> follows the same principle as SQL or Oracle’s transaction command. The syntax for this tag is

<CFTRANSACTION ACTION="begin or commit or rollback"
    ISOLATION ="read_uncommitted or read_committed or repeatable_read">
</CFTRANSACTION>


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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