Rediger i databasen
Jeg har et community, og er ved at lave en rediger info funktion, og når jeg prøver det af kommer denne fejl:Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'id='.
/syntax/hh-spray/community/rediger.asp, line 22
Scriptet er:
<html>
<head>
<title>EditUser</title>
</head>
<body>
<p><b>Profilredigering</b>
<%
If Session("login") = false Then
response.write "<meta HTTP-EQUIV=""REFRESH"" CONTENT=""00000000; URL=login.asp"">"
End If
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath ("com123.mdb")
Conn.Open DSN
Dim samletAntal
strSQL = "SELECT * FROM brugere WHERE id=" & session("userid")
Set rs = Conn.Execute(strSQL)
response.write "<p><b>" & rs("brugernavn") & "</b>"
%>
<form method="post" action="opdater.asp">
<input type="hidden" name="id" size="50" value="<%=rs("id")%>">
<p>Password:<font color="red"> *</font><br>
<input name="password" maxlength="50" size="50" value="<%=rs("kode")%>">
<p>E-mail adresse:<font color="red"> *</font><br>
<input type="text" name="email" maxlength="50" size="50" value="<%=rs("mail")%>">
<p>ICQ:<br>
<input type="text" name="icq" maxlength="50" size="50" value="<%=rs("icq")%>">
<p>Hjemmeside:<br>
<input type="text" name="hjemmeside" maxlength="50" size="50" value="<%=rs("homepage")%>">
<p><br>
<input type="submit" value="Opdater">
<input type="reset" value="Fortryd ændringer">
</form>
<font color="red">*</font>= Felt, der kræves udfyldt
<%
Conn.Close
Set Conn = Nothing
%>
</body>
</html>
