odd, it started working! maybe it was just taking a while for the ftp programme to update the file listings...
thanks anyway! Ian W ----- Original Message ----- From: "Adrian Lynch" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 5:29 PM Subject: RE: [ cf-dev ] cffile action=delete > 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] > -- ** 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]
