Missing statement
JEG FÅR FØLGENDE FEJL:Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression 'id ='.
/racepalace/asp/sletbook.asp, line 40
MIN CODE ER:
<%
fejl = ""
If Request("Submit")<>"" Then
If Request("kode") = RS("kodeord") Then
Conn.Execute("DELETE FROM booking WHERE id = " & request("id") & " order by id;")
responce.write "booking slettet"
Else
fejl = "Forkert kodeord. Prøv igen!"
End If
End If
%>
<html>
<STYLE>
BODY {
background-color: black;
color: #DC2B19;
background-image: url("images/newsbg.gif");
background-repeat: no-repeat;
}
A {font: 10pt Arial;text-decoration: none}
A:Hover {color:#DC2B19}
B {font: 12pt Arial;text-decoration: none}
C {font: 12pt Arial;text-decoration: none}
</STYLE>
<BODY bgcolor="000000"
LINK="#ffffff"
TEXT="#DC2B19"
VLINK="#FFFFFF"
ALINK="#FF0000">
<%
strDSN = "Driver={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("medlem.mdb")
set conn = server.createobject("ADODB.connection")
conn.open strDSN
SQL = "select * from booking where id = " & request("id") & " order by id;"
linktype = "blabla"
set RS = conn.execute( SQL )
do while not RS.eof
%>
<form action="sletbook.asp" method="post">
<table><tr><td></td>
<td colspan="2"><font color="#0080FF" face="verdana" size="2"><b></b></font></td></tr>
<%If fejl <> "" Then%>
<tr><td></td>
<td colspan="2"><center><font size=1 face=verdana color=red><%=fejl%></font></center></td></tr>
<%End If%>
<tr> <td></td>
<td><font size=2 face=verdana>Kodeord:</font></td>
<td><Input type="text" name="kode"></td></tr>
<tr><td></td>
<td colspan="2"><center><input type="submit" name="submit" value="Bekræft"></center></td></tr>
<tr><td></td>
<td colspan="2"><center><font size=2 face=verdana></font></center></td>
</tr>
</table>
</form>
<%
RS.movenext
loop
conn.Close
%>
<BR>
<A HREF="http://192.168.0.1/racepalace/main/booket1.htm">Tilbage</A>
</body>
</html>
FILEN BLIVER KALDT SÅLEDES:
<A HREF="sletbook.asp?id=<%=RS("id")%>">Slet booking</A>
Jeg kan ikke rigtigt forstå hvad der er galt !!! er der nogen der kan hjælpe mig ???
