Tom Kitta wrote: > 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.
Depends. I can first do the database update, then try the FTP and if the FTP fails roll back the database update. I can not do it the other way around because I can not undo an FTP put in a dropbox. Also, not all databases require locking to provide transactional integrity. Databases that use some sort of multiversioning instead of locking generally suffer far less consequences from a long running transaction. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271484 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
