Hjælp til at slette et billede fra en database upload
Hejsa Alle Eksperter.....Jeg har en upload som fungerer kanont..
jeg mangler bare en feature, og det er at kunne slette de tre billeder der er blevet uploadet enkeltvis...
Koden til siden ser sådan ud...:
-----------------------
<html>
<head>
<meta http-equiv="Content-Language" content="da">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Salgsliste</title>
</head>
<body>
<%
mode=request.querystring("m")
if mode="gem" then
sti = "billeder/"
Set Upload = Server.CreateObject("Persits.Upload")
set conn = server.createobject("ADODB.connection")
path = Server.MapPath("db/fpdb/sha.mdb")
conn.Open "DBQ="& path &";DefaultDir="& path & ";Driver={Microsoft Access Driver (*.mdb)}"
Upload.OverwriteFiles = False
Upload.Save (Server.Mappath(sti))
fil1 = ""
fil2 = ""
fil3 = ""
If Not Upload.Files("FILE1") Is Nothing Then fil1 = sti & Upload.Files("FILE1").FileName
If Not Upload.Files("FILE2") Is Nothing Then fil2 = sti & Upload.Files("FILE2").FileName
If Not Upload.Files("FILE3") Is Nothing Then fil3 = sti & Upload.Files("FILE3").FileName
SQL="UPDATE tblBILSALG SET "
SQL = SQL & "oprettet='" & Upload.form("oprettet") & "', "
SQL = SQL & "[Mærke]='" & Upload.form("Mærke") & "', "
SQL = SQL & "[Model]='" & Upload.form("Model") & "', "
SQL = SQL & "[Type]='" & Upload.form("Type") & "', "
SQL = SQL & "[Brændstof]='" & Upload.form("Brændstof") & "', "
SQL = SQL & "Farve='" & Upload.form("Farve") & "', "
SQL = SQL & "[Årgang]='" & Upload.form("Årgang") & "', "
SQL = SQL & "Kilometer='" & Upload.form("Kilometer") & "', "
SQL = SQL & "Pris='" & Upload.form("Pris") & "', "
SQL = SQL & "Synet='" & Upload.form("Synet") & "', "
SQL = SQL & "Beskrivelse='" & Upload.form("Beskrivelse") & "' "
if fil1 <> "" then SQL = SQL & ",[Billede 1]='" & fil1 & "' "
if fil2 <> "" then SQL = SQL & ",[Billede 2]='" & fil2 & "' "
if fil3 <> "" then SQL = SQL & ",[Billede 3]='" & fil3 & "' "
SQL = SQL & " where ID_bil =" & request.querystring("ID_bil")
Set RS = Conn.Execute(SQL)
%><font face="Verdana"><span style="font-size: 9pt"> <meta http-equiv="refresh" content="2;URL=lukker.asp">
<font color="#FF0000">Dine ændringer er nu gemt.</font></span></font><b><font face="Verdana"><span style="font-size: 9pt">
<% else %>
<%
set conn = server.createobject("ADODB.connection")
path = Server.MapPath("db/fpdb/sha.mdb")
conn.Open "DBQ="& path &";DefaultDir="& path & ";Driver={Microsoft Access Driver (*.mdb)}"
SQL = "SELECT * from tblBILSALG where Id_bil = " & Request.Querystring("ID_bil")
set RS = Conn.Execute(SQL)
Session("editID") = Request.Querystring("ID_bil")
%></span></font><form method="POST" action="fjernsalgsliste.asp?m=gem&id_bil=<%=rs("ID_bil") %>" enctype="multipart/form-data">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" height="44">
<tr>
<td height="22"><font face="Verdana" style="font-size: 9pt">Oprettet:</font></td>
<td height="22"><font face="Verdana"><span style="font-size: 9pt"><input type="text" name="oprettet" size="50" value="<%=rs("oprettet") %>"></span></font></td>
</tr>
<tr>
<td height="22"><font face="Verdana" style="font-size: 9pt">Mærke:</font></td>
<td height="22"><b>
<font face="Verdana"><span style="font-size: 9pt">
<input type="text" name="Mærke" size="50" value="<%=rs("Mærke") %>"></span></font></b></td>
</tr>
<tr>
<td height="22"><font face="Verdana" style="font-size: 9pt">Model:</font></td>
<td height="22"><b>
<font face="Verdana"><span style="font-size: 9pt">
<input type="text" name="model" size="50" value="<%=rs("Model") %>"></span></font></b></td>
</tr>
<tr>
<td height="22"><font face="Verdana" style="font-size: 9pt">Type:</font></td>
<td height="22"><b>
<font face="Verdana"><span style="font-size: 9pt">
<input type="text" name="Type" size="50" value="<%=rs("Type") %>"></span></font></b></td>
</tr>
<tr>
<td height="22"><font face="Verdana" style="font-size: 9pt">Brændstof:</font></td>
<td height="22"><b>
<font face="Verdana"><span style="font-size: 9pt">
<input type="text" name="Brændstof" size="50" value="<%=rs("Brændstof") %>"></span></font></b></td>
</tr>
<tr>
<td height="22"><font face="Verdana" style="font-size: 9pt">Farve:</font></td>
<td height="22"><b>
<font face="Verdana"><span style="font-size: 9pt">
<input type="text" name="Farve" size="50" value="<%=rs("Farve") %>"></span></font></b></td>
</tr>
<tr>
<td height="22"><font face="Verdana" style="font-size: 9pt">Årgang:</font></td>
<td height="22"><b>
<font face="Verdana"><span style="font-size: 9pt">
<input type="text" name="Årgang" size="50" value="<%=rs("Årgang") %>"></span></font></b></td>
</tr>
<tr>
<td height="22"><font face="Verdana" style="font-size: 9pt">Kilometer:</font></td>
<td height="22"><b>
<font face="Verdana"><span style="font-size: 9pt">
<input type="text" name="Kilometer" size="50" value="<%=rs("kilometer") %>"></span></font></b></td>
</tr>
<tr>
<td height="22"><font face="Verdana" style="font-size: 9pt">Pris:</font></td>
<td height="22"><b>
<font face="Verdana"><span style="font-size: 9pt">
<input type="text" name="Pris" size="50" value="<%=rs("Pris") %>"></span></font></b></td>
</tr>
<tr>
<td height="22"><font face="Verdana" style="font-size: 9pt">Synet:</font></td>
<td height="22"><b>
<font face="Verdana"><span style="font-size: 9pt">
<input type="text" name="synet" size="50" value="<%=rs("synet") %>"></span></font></b></td>
</tr>
<tr>
<td height="22" valign="top">
<font face="Verdana" style="font-size: 9pt">Beskrivelse:</font></td>
<td height="22"><font face="Verdana"><span style="font-size: 9pt"><textarea rows="8" name="Beskrivelse" cols="40"><%=rs("Beskrivelse") %></textarea></span></font></td>
</tr>
<tr>
<td height="22" valign="top"><font face="Verdana" style="font-size: 9pt">Billede 1:</font></td>
<td height="22" valign="top"><font face="Verdana"><span style="font-size: 9pt"><INPUT TYPE="FILE" SIZE="35" NAME="FILE1"><br>
</span><span style="font-size: 7pt">
<!--webbot bot="HTMLMarkup" startspan --><%=rs("Billede 1") %><!--webbot bot="HTMLMarkup" endspan --></span></font></td>
</tr>
<tr>
<td height="22" valign="top"><font face="Verdana" style="font-size: 9pt">Billede 2:</font></td>
<td height="22" valign="top"><font face="Verdana"><span style="font-size: 9pt"><INPUT TYPE="FILE" SIZE="35" NAME="FILE2"><br>
</span><span style="font-size: 7pt">
<!--webbot bot="HTMLMarkup" startspan --><%=rs("Billede 2") %><!--webbot bot="HTMLMarkup" endspan --></span></font></td>
</tr>
<tr>
<td height="22" valign="top"><font face="Verdana" style="font-size: 9pt">Billede 3:</font></td>
<td height="22" valign="top"><font face="Verdana"><span style="font-size: 9pt"><INPUT TYPE="FILE" SIZE="35" NAME="FILE3"><br>
</span><span style="font-size: 7pt">
<!--webbot bot="HTMLMarkup" startspan --><%=rs("Billede 3") %><!--webbot bot="HTMLMarkup" endspan --></span></font></td>
</tr>
</table>
</center>
</div>
<p align="center">
<font face="Verdana"><span style="font-size: 9pt">
<br>
<span style="font-size: 8pt">
<input type="submit" value="Gem" name="gem"></span> </span></font>
</p>
</form>
</b>
<font face="Verdana" style="font-size: 9pt">
<% end if %>
</font>
</body>
</html>
---------------------
Er der nogen der kender en løsning...
Alt data er gemt i en Access DB
/Toke
