(missing operator)
Jeg for følgende fejlkode:
Microsoft OLE DB Provider for ODBC Drivers error \'80040e14\'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression \'id =\'.
/aspforum/kartotek/vis_data_alt.asp, line 20
I følgende script:
<html>
<head>
<title>Vis adresser</title>
</head>
<body>
<%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"../forum.mdb\")
SQLstmt = \"SELECT * FROM forums WHERE id =\" & Request(\"Id\")
Conn.Execute (SQLstmt)
Set rs = conn.Execute(SQLstmt)
%>
<table border=\"0\" width=\"400\" bgcolor=\"#7D9BB9\" cellspacing=\"0\" cellpadding=\"0\" style=\"border: 1 solid #000000\">
<tr>
<td valign=\"middle\" bgcolor=\"#54789C\" colspan=\"3\" align=\"right\" height=\"18\" width=\"396\"><font color=\"#FFFFFF\" face=\"verdana\" size=\"1\">[<a href=\"default.asp\" style=\"color: #FFFFFF\">Til
forsiden</a> ] [ <a href=\"ret_i_data.asp?id=<%=rs(\"id\")%>\" style=\"color: #FFFFFF\">Ret
i post</a> ] [<a href=\"adresser.asp\" style=\"color: #FFFFFF\">
Indtast ny post</a> ] [ <a href=\"slet_data.asp?id=<%=rs(\"id\")%>\" style=\"color: #FFFFFF\">Slet
post</a> ]</font></td>
<tr>
<td valign=\"top\" bgcolor=\"#FFFFFF\" colspan=\"3\" align=\"right\" height=\"1\" width=\"396\"><img border=\"0\" src=\"1x1.gif\" width=\"1\" height=\"1\"></td>
<tr>
<td valign=\"top\" bgcolor=\"#000000\" width=\"396\" colspan=\"3\" height=\"18\"><font color=\"#FFFFFF\" face=\"Arial\" size=\"2\"><b>Information
om,</b></font></td>
<%
\'DO WHILE NOT rs.EOF
forum = rs(\"Forum\")
description = rs(\"Description\")
%>
<tr>
<td bgcolor=\"#7D9BB9\" width=\"9\"><img border=\"0\" src=\"1x1-trans.gif\" width=\"1\" height=\"1\"></td>
<td valign=\"top\" align=\"left\" bgcolor=\"#7D9BB9\" width=\"128\"><b><font face=\"Arial\" size=\"2\" color=\"#FFFFFF\">Forum titel</font></b></td>
<td align=\"left\" valign=\"top\" bgcolor=\"#7D9BB9\" width=\"255\"><font face=\"Arial\" size=\"2\"><b><%=forum%></b></font></td>
</tr>
<tr>
<td bgcolor=\"#7D9BB9\" width=\"9\"><img border=\"0\" src=\"1x1-trans.gif\" width=\"1\" height=\"1\"></td>
<td valign=\"top\" align=\"left\" bgcolor=\"#7D9BB9\" width=\"128\"><font face=\"Arial\" size=\"2\" color=\"#FFFFFF\"><b>beskrivelse</b></font></td>
<td align=\"left\" valign=\"top\" bgcolor=\"#7D9BB9\" width=\"255\"><font face=\"Arial\" size=\"2\"><b><%=description%></b></font></td>
</tr>
<tr>
<td bgcolor=\"#FFFFFF\" colspan=\"3\" height=\"1\" width=\"396\"><img border=\"0\" src=\"1x1.gif\" width=\"1\" height=\"1\"><img border=\"0\" src=\"1x1-trans.gif\" width=\"1\" height=\"1\"></td>
</tr>
<tr>
<%
\'rs.MoveNext
\'LOOP
\'RS.Close
Response.Write \"</TABLE>\"
conn.Close
Set conn = nothing
Set SQLstmt = nothing
%>
</tr>
</table>
</body>
</html>
Hvad gør jeg forkert? Det må jo være í forbindelse med at Id skal defineres
