Panos
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?
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>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you again for your help.
regards
panos