You should only use cftransaction tag to make sequence of SQL statements into one atomic unit. You should never have anything inside your cftransaction block that is not SQL related especially if its going to take a long time (i.e. more than few ms). You don't want to lock your SQL server DBs because some operation such as FTP is taking place.
cftransaction will rollback if there is an error in the SQL executed within it. You can also use the rollback option to rollback on some user error. The rollback here refers only to SQL. To answer your question, no cftransaction will not delete any files etc. for you, it is only for SQL. TK ----- Original Message ----- From: "Deepak Gupta" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Sunday, March 04, 2007 1:31 PM Subject: <cftransaction> Question > Hi Everyone > > I am using cftransaction around few things > 1> Reading a file to my local from ftp site > 2> query to insert > 3> query to loop and do some operations > 4> zip files > > Now according cftransaction if there is any error in these > functionalities, it should rollback to the initial stage right? But its > not working in my case. > It picks the file from ftp to local, then there is an error in query, it > stops there but doesn't rollback ( i mean it doesn't remove the file read > on local ). It should remove the file read through FTP rite? > > Code Used: > <cftransaction> > <cftry> > 1- FTP read > 2-Query ( Error one) > > <cftransaction action="commit" /> > <cfcatch type="tran"> > <cftransaction action="rollback" /> > <cfset request.lstErrorMessages = > ListAppend(request.lstErrorMessages,cfcatch.message)> > </cfcatch> > <cfcatch type="any"> > <cftransaction action="rollback" /> > <cfset request.lstErrorMessages = > ListAppend(request.lstErrorMessages,cfcatch.message)> > </cfcatch> > </cftry> > </cftransaction> > Can anyone help[ me with this one. what is wrong with this approach? > > DG > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271460 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
