cftransaction

action = "begin|commit|rollback|setsavepoint"
isolation = "read_uncommitted|read_committed|repeatable_read"
savepoint = "savepoint name">
</cftransaction>

<cftransaction> 
<cfquery name="iquery" datasource="dsn"> 
insert into region(regionid, regiondescription) values('111', 'YPR') 
</cfquery> 
<cftransaction> 
<cfquery name="iquery" datasource="dsn"> 
update region set regiondescription = 'new' where regionid='111' 
</cfquery> 
</cftransaction> 
</cftransaction>

the cfquery tag into one business event. Changes to data that is requested
by the queries are not committed to the datasource until all actions within
the transaction block have executed successfully.
<p>This a view-only example.
<!---
<cftransaction>
<cfquery name='makeNewCourse' datasource='Snippets'>
INSERT INTO Courses
(Number, Descript)
VALUES
('#myNumber#', '#myDescription#')
</cfquery>

<cfquery name='insertNewCourseToList' datasource='Snippets'>
INSERT INTO CourseList
(CorNumber, CorDesc, Dept_ID,
CorName, CorLevel, LastUpdate)
VALUES
('#myNumber#', '#myDescription#', '#myDepartment#',
'#myDescription#', '#myCorLevel#', #Now()#)
</cfquery>
</cftransaction>
--->

<!--- This example performs batch processing of withdrawals ---> 
<!--- from a bank account. The withdrawal amounts are stored ---> 
<!--- in an array. ---> 
<!--- There is a CFC named bank.cfc whose contains appear --->
<!--- after the example. ---> 

<cftransaction> 
<!--- Get the account balance. ---> 
<cfinvoke component="bank" method="getBalance" 
returnvariable="getacctbalance" accountnum=1> 

<cfloop index="withdrawnum" from="1" to="#ArrayLen(withdrawals)#"> 
<!--- Set a savepoint before making the withdrawal. ---> 
<cfset noxfer = "point" & #withdrawnum#> 
<cftransaction action = "setsavepoint" savepoint = "#noxfer#"/> 

<!--- Make the withdrawal. ---> 
<cfinvoke component="bank" method="makewithdrawal" 
returnvariable="getacctbalance" accountnum=1 
withdrawamount="#withdrawals[withdrawnum]#"> 

<!--- Get the account balance. ---> 
<cfinvoke component="bank" method="getBalance" 
returnvariable="getacctbalance" accountnum=1> 

<!--- If the balance is negative, roll back the transaction. ---> 
<cfif getacctbalance.balance lt 0> 
<cftransaction action="rollback" savepoint="#noxfer#" /> 
</cfif> 
</cfloop> 
</cftransaction> 

<!--- The bank.cfc contains the following: 

cfcomponent> 
<cffunction name="getBalance" access="public" returntype="query"> 
<cfargument name="accountnum" type="numeric" required="yes"> 
<cfquery name="getacctbalance" datasource="testsqlserver"> 
SELECT * FROM dbo.mybank 
WHERE accountid = #accountnum# 
</cfquery> 
<cfreturn getacctbalance> 
</cffunction> 

<cffunction name="makewithdrawal" access="public" returntype="query"> 
<cfargument name="accountnum" type="numeric" required="yes"> 
<cfargument name="withdrawamount" type="numeric" required="yes"> 
<cfquery name="withdrawfromacct" datasource="testsqlserver"> 
UPDATE dbo.mybank SET balance = balance - #withdrawamount# 
WHERE accountid = 1 
</cfquery> 
<cfinvoke method="getBalance" returnvariable="getacctbalance" 
accountnum=1> 
<cfreturn getacctbalance> 
</cffunction> 
</cfcomponent> 
--->