Solved

Delete file with a button

Posted on 2008-06-25
2
147 Views
Last Modified: 2013-12-16
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

0
Comment
Question by:Panos
2 Comments
 
LVL 63

Accepted Solution

by:
Zvonko earned 500 total points
ID: 21896813
Change this:
<input type="checkbox" name="Deletimg_1" id="Deletimg_1"  value="1"/>Delete<br>

To this:
<input type="submit" name="Deletimg_1" id="Deletimg_1"  value="Delete" ><br>


0
 
LVL 2

Author Closing Comment

by:Panos
ID: 31470521
Hi Zvonko.
Thank you again for your help.
regards
panos
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I will be creating today a basic tutorial on how we can create a Mail Custom Function and use it where ever we want. The main advantage about creating a custom function is that we can accommodate a range of arguments to pass to the Function and …
Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question