As a quick debug, output #fdest#/#getimagename.eventimage# to check it's the correct path to the file. If that's ok, see if it gets deleted outside of the transaction, god knows if that has anything to do with it but at least you'll know.
Ade -----Original Message----- From: Ian Westbrook [mailto:[EMAIL PROTECTED] Sent: 23 September 2003 17:14 To: cfug dev list Subject: [ cf-dev ] cffile action=delete I can't see anything wrong with this this is the code: <cftransaction> <cfquery datasource="#dsn#" name="getimagename"> SELECT eventimage FROM diary WHERE id = #url.diaryid# </cfquery> <cfset fdest= expandpath("../images/diary")> <cfoutput><cffile action="DELETE" FILE="#fdest#/#getimagename.eventimage#"></cfoutput> <cfquery datasource="#dsn#"> UPDATE diary SET eventimage = '' WHERE id = #url.diaryid# </cfquery> </cftransaction> anyone any idea why the file is still there after I run it? CF4.5, Access db TIA Ian W -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
