Hej
Jeg skal have lavet et script der kan slette en nyhed i en database hvor man
skal skrive i en <form> hvad den skal slette.
Mit Script ser sådan ud :
<%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath ("news.mdb")
Conn.Open DSN
' Luk databaseforbindelse
Conn.Close
Set Conn = Nothing
If Request.Form("slet") <> "" Then
strSQL = "Delete from news where overskrift = " & Request.Form("slet") & ""
Conn.Execute(strSQL)
rs.Close
Set rs = Nothing
End if
%>
<html>
<head>
<title>Nyheder</title>
</head>
<body style="background-color: #32679C">
<div align="center"><center><table width="488" border="0" cellspacing="0"
cellpadding="3">
<tr>
<td width="488"><span style="text-decoration: overline"><u><font
face="Arial" size="6" color="#FFFFFF">|Slet
Nyheder|</font></u></span><br><br><font face="Arial" size="2"
color="#FFFFFF">Indtast den information du vil slette i The Complex's
nyhedsbrev. <br><br></font></td>
</tr>
<tr align="center">
<td width="100%">
<form method="POST" action="default.asp">
</form>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td valign="middle" align="left" colspan="2"><font face="arial"
size="2" color="#FFFFFF"><B>
</B>Indtast venligst oplysningerne i følgende felter :<B><br>
</B></font></td>
</tr>
<tr>
<td valign="middle" align="left"><div align="left"><p><font
face="arial" size="2" color="#FFFFFF">Overskrift</font></td>
<td valign="middle" align="left"><input type="text" name="slet"
size="40"></td>
</tr>
<tr>
<td valign="middle" align="left" colspan="2"><br>
<input type="submit" value="slet" name="slet"> <input
type="button" value="Annuller" name="Annuller"
onClick="javascript:history.back();"></td>
</tr>
</table>
</form>
</tr>
</table>
</center></div>
</body>
</html>
Hvad er fejlen, der sker nemlig ikke noget når jeg trykker på knappen Slet.
Mvh
Kenneth