I think we are into this big 'depends' here conversation - yes if your FTP is needed in the middle of the processing and it runs once in a while the transaction is one way to go. However, it would create some issues if it is to be run like 10 times a second on a server.
As for the DB - I guess I am too much into that SQL Server thing - the dark side is clouding my vision :) TK > > 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:271542 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
