CFTRANSACTION  
 
 

Use CFTRANSACTION to group multiple queries into a single unit. CFTRANSACTION can also provide rollback processing.

 
 
  Syntax  
 
<CFTRANSACTION ISOLATION="ODBC_lock">
...
</CFTRANSACTION>

ISOLATION

Optional. ODBC lock type. Valid entries are:

  • Read_Uncommitted
  • Read_Committed
  • Repeatable_Read
  • Serializable
 
 
  Usage  
 

Any queries executed with CFQUERY and placed between <CFTRANSACTION> and </CFTRANSACTION> tags are treated as a single transaction. Changes to data requested by these queries are not committed to the database until all actions within the transaction block have executed successfully. If an error occurs in a query, all changes made by previous queries within the transaction block are rolled back.

Use the ISOLATION attribute for additional control over how the database engine performs locking during the transaction.





 
 
BackUp LevelNext
 
 

allaire     AllaireDoc@allaire.com
    Copyright © 1998, Allaire Corporation. All rights reserved.