[ cf-dev ] cffile action=delete

[Ian Westbrook]

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