ret fejlen i slet funktion
Hej alle, har lidt problemer med slet funktion.I starten var denne fil kun en aktiverings funk og virkede fint. men jeg ville også have mulighed for at slette dem jeg ikke vil aktiver.
har ændret lidt på koden og får denne fejl:
Der er en syntaksfejl, fordi der mangler en operator. i forespørgselsudtrykket "id = &request(13)".
<%
set conn=server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../../db/celikan_com.mdb")
if request.servervariables("REQUEST_METHOD") = "POST" then
'opdater
slet = Request.Form("slet")
ider = Request.Form("aktiv")
if ider<>"" then
SQL = "update site_uye set aktiv=1 where id in (" &ider & ")"
else
if slet<>"" then
SQL = "Delete * from site_uye where id = &request(" &slet & ")"
Conn.Execute(SQL)
End if
end if
Response.redirect(request.Servervariables("SCRIPT_NAME"))
end if
%>
<html>
<head>
<title>Godkend brugerne</title>
<style type="text/css">
<!--
td {
font-family: verdana;
font-size: 9px;
}
-->
</style>
</head>
<body bgcolor="#FFCC99">
<%
sql = "select * from site_uye where aktiv=0"
set rs=Conn.Execute(SQL)
response.write "<table border=1>"
response.write "<form action=""" & request.ServerVariables("SCRIPT_NAME")&""" method=""post"">"
response.write "<tr><td>Aktiver</td><td>ID</td><td>Isim</td><td>Soyad</td><td>Nickname</td><td>Email</td><td>Yer</td><td>Tarih</td></tr>"
do while not rs.EOF
response.write "<tr>"
response.write "<td>Aktiver <input type=""checkbox"" name=""aktiv"" value=""" & rs("id") & """></td>"
response.write "<td>" & rs("id") & "</td>"
response.write "<td>Slet <input type=""checkbox"" name=""slet"" value=""" & rs("id") & """></td>"
response.write "<td>" & rs("adi") & "</td>"
response.write "<td>" & rs("soyadi") & "</td>"
response.write "<td>" & rs("nickname") & "</td>"
response.write "<td>" & rs("email") & "</td>"
' response.write "<td>" & rs("web") & "</td>"
response.write "<td>" & rs("yer") & "</td>"
response.write "<td>" & rs("tarih") & "</td>"
response.write "</tr>"
rs.Movenext
loop
%>
</table>
<input type="submit" name="aktiver" value="Aktiver">
</form>
<center>
<a href="default.asp">Geri Dön</a>
</center>
</body>
</html>
