Commits the current active transaction.

Transaction Functions

transactionRollback transactionSetSavePoint

ColdFusion 9: Added this function.

TransactionCommit()

Nothing

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>