Commits the current active transaction.
Nothing
TransactionCommit()
TransactionRollback, TransactionSetSavePoint
ColdFusion 9: Added this function.
You can call this function only from within an active transaction.
<cfscript>
q = new query();
q.setDatasource("cfartgallery");
WriteDump(q.execute(sql="select * from art where artid = 60").getResult());
transaction
{
q.execute(sql="insert into art (artid,artistid,artname,description,price) values (60,3,'tom','tom',2000)");
transactionSetSavePoint('sp1');
WriteDump(q.execute(sql="select * from art where artid = 60").getResult());
transaction
{
q.execute(sql="update art set artistid=4 where artid = 60");
transactionSetSavePoint('sp2');
WriteDump(q.execute(sql="select * from art where artid = 60").getResult());
transaction
{
try
{
q.execute(sql="update art set artistid='badvalue' where artid = 60");
}
catch(any e)
{
WriteLog("rolling back the transaction");
transactionRollback("sp1");
}
}
}
}
WriteDump(q.execute(sql="select * from art where artid = 60").getResult());
transaction
{
WriteLog("deleting the record");
q.execute(sql="delete from art where artid = 60");
WriteDump(q.execute(sql="select * from art where artid = 60").getResult());
}
</cfscript>
Twitter™ and Facebook posts are not covered under the terms of Creative Commons.