Can't CFLOCK be used for this sort of thing? Although, I saw another post that suggested using random filenames, instead of hard coded ones. It also seems like a good solution if you do not want to force this code to be single threaded. CF-Community wrote: > Date: Mon, 01 Jan 2001 12:03:12 -0500 > From: "Jim Watkins" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: CFX Excel Problem > Message-ID: <001c01c07414$cbc754a0$0c15020a@jwatkinshome> > > When more than one person attempts to activate the following tag at the same > time the OUTPUT1.XLS file is not deleted and the next person gets an error. > I then have to turn off the Webserver in NT Services and restart in order to > delete the file so the script will run again. Does anyone have a solution > to this? > > <CFX_Excel Query="roster" > Version="2000" > File="d:\templates\OUTPUT1.XLS" > Workbook="D:\TEMPLATES\GradeSheet.XLS" > Worksheet="Sheet1" > Headers="N" > Row="3" > Column="1"> > <cfheader name="Content-Disposition" value="inline; > filename='Gradesheet.xls'"> > <cfcontent type="application/msexcel" file="d:\templates\OUTPUT1.XLS" > deletefile="YES"> > > Jim Watkins > http://www.ngtcollege.org > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > -- Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Acoustic Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- Promise me no dead end streets, and I'll guarantee we'll have a road ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
