Have u tried outputting that path to make sure it is correct or using fileExists() first
------------------------------------------------------------------------ - FIGHT BACK AGAINST SPAM! Download Spam Inspector, the Award Winning Anti-Spam Filter http://mail.giantcompany.com -----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]