Link to home
Start Free TrialLog in
Avatar of Panos
PanosFlag for Germany

asked on

Delete file with a button

Hello experts.
I have one update page where i'm uploading and deleting images.
For the delete function i use a checkbox.
Instead of that can i use a button?
<CFSET thispath = expandpath("./images")>
  <cfif structKeyExists(form,"foto1") and len(form.foto1)><!--- uploads a file to our website --->
  <CFFILE action="upload" filefield="foto1" destination="#thispath#" nameconflict="MAKEUNIQUE">
    <cfimage name="uploadedImage"
   source="#thispath#/#cffile.serverFile#" >
   ......
   .....
   <CFSET ServerFile1 = FILE.SERVERFILE></cfif>
 
   <cfif isdefined ("Deletimg_1")>
   <cffile action="delete" file="#thispath#/#artikel.Photo1#">
   <cfset ServerFile1 = images_1.jpg>
   </cfif>
   <CFFILE action="upload" filefield="foto2" destination="#thispath#" nameconflict="MAKEUNIQUE">
   <cfimage name="uploadedImage"
   source="#thispath#/#cffile.serverFile#" >
   ......
   ......
   <CFSET ServerFile2 = FILE.SERVERFILE>
  </cfif>
  
<cfquery name="artikel" datasource="#dsn#">
SELECT a.Art_ID, a.Photo1, a.Photo2
FROM dbo.artikel a 
WHERE Art_ID = <cfqueryparam value="#URL.Art_ID#" cfsqltype="cf_sql_numeric"> OR ( -1= <cfqueryparam value="#WADA_URL_Art_ID#" cfsqltype="cf_sql_numeric"> AND Art_ID=<cfqueryparam value="#SESSION.WADA_Insert_dboartikel#" cfsqltype="cf_sql_numeric">) 
</cfquery> 
 
<cfparam name="SERVERFILE1" default="">
<cfparam name="SERVERFILE2" default="">
 
<cfif CGI.REQUEST_METHOD IS "POST">
<cfinclude template="Includes/uploadhelper.cfm">
<cfquery name="imageupload" datasource="#dsn#">
Update dbo.artikel
SET photo1 =<Cfif len(ServerFile1)>'#ServerFile1#'<cfelse>photo1</cfif>,
    photo2 =<Cfif len(ServerFile2)>'#ServerFile2#'<cfelse>photo2</cfif>
   
   Where Art_Id= <cfqueryparam value="#URLEncodedFormat(artikel.Art_ID)#"> 
</cfquery>
<cflocation url="InsertPhoto.cfm?Art_ID=#URLEncodedFormat(artikel.Art_ID)#">
</cfif>
 
 
<form action="#CGI.SCRIPT_NAME#" method="post" enctype="multipart/form-data" name="UpdateForm" id="UpdateForm">
<input name="imageField" type="image" id="imageField" src="images/<cfoutput>#artikel.Photo1#</cfoutput>" align="left" width="80" height="60" />
<input name="foto1" class="textfieldfoto" type="file" size="20" /><input type="checkbox" name="Deletimg_1" id="Deletimg_1"  value="1"/>Delete<br>
<input name="imageField2" type="image" id="imageField2" src="images/<cfoutput>#artikel.Photo2#</cfoutput>" align="left" width="80" height="60" />
<input name="foto2" class="textfieldfoto" type="file" size="20" />
<input type="submit"  lang="de"  height="30" width="60" name="update" id="update" value="Upload" />
</form>

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Zvonko
Zvonko
Flag of North Macedonia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Panos

ASKER

Hi Zvonko.
Thank you again for your help.
regards
panos