slet sql sætting..
Fejltype:Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access-driver] Der er en syntaksfejl, fordi der mangler en operator. i forespørgselsudtrykket "id =".
/fest/opdatere.asp, line 12
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("fest.mdb")
Conn.Open DSN
if session("login") > "" then
if request.QueryString("n") = "1" then
sql = "UPDATE fest set tilstand = 1 where id = "&request.QueryString("id")&""
Conn.Execute(sql)
Else
sql = "UPDATE fest set tilstand = 0 where id = "&request.QueryString("id")&""
Conn.Execute(sql)
end if
if request.QueryString("slet") > "" then
id = request.QueryString("slet")
---->line 12 SQL = "DELETE * FROM fest WHERE ID= '" & id &"'"
Conn.Execute(sql)
end if
Conn.Close
Set Conn = Nothing
end if
response.Redirect("admin.asp")
%>
