Are you using the timeout option? If you don't specify one then the file will be locked. I have seen this problem when a command takes too long. I just moved on to CFX_consolecommand.
Neil ----- Original Message ----- From: "Seth Petry-Johnson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 3:48 PM Subject: Weird problem with CFEXECUTE not releasing file > I have been having a rather strange problem with trying to delete text files > created using the OUTPUTFILE attribute of the CFEXECUTE tag on CF 4.51, > running on Win 2k Professional. It seems that any file I create using > CFEXECUTE gets stuck in a locked state after I try to programatically delete > it. > > Here's what my app is supposed to do: > > 1) I use CF to create a batch file containing multiple command line commands > to run. > 2) I call CFEXECUTE to run this batch file and save the results to a text > file for later debugging if needed. > 3) When the database record that the batch file relates to is deleted my > cleanup code attempts to delete both the batch file and the result text > file, since they are no longer needed. > > The problem is that result text file, the one created by CFEXECUTE, never > gets deleted. If I try to delete it by hand, or even view it in notepad, > I'm told the file is in use and can not be accessed. Cycling the CF > application service apparently frees up the text file because it disappears > as soon as I do so. The batch files (which are created by CFFILE) are > deleted without issue. > > The strange thing is that the text file is NOT locked until step 3. In > other words, after the batch file and text file are created I can edit them > or delete them just fine, but once I initiate the cleanup code they get > stuck. Also, I have tried deleting the files both using CFFILE and also by > creating another batch file that deletes them. I get the same results with > both approaches. > > I'm grasping at straws and hoping that someone has seen this behaviour > before... any suggestions? > > Thanks in advance, > Seth Petry-Johnson > Argo Enterprise and Associates > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
