Opdatering af felt
Hej, er der en venlig sjæl der kan fortælle mig hvorfor jeg ikke kan få lov at opdatere uden at få flg. fejl:Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'brugerId ='.
/login_admin.asp, line 399
Koden ser således ud:
Bliver kaldt fra:
<a href="login_admin.asp?mode=ejerprofil&Id=<% = rs.Fields("brugerId")%>"><%=rs("brugerNavn")%></a>
<% if mode = "ejerprofil" then
'Tjecker om admin er logget ind
if session("adminnavn") = "" then
Response.Redirect("login_admin.asp?mode=login")
end if
'Henter brugerens profil
Set rs = Server.CreateObject ("ADODB.Recordset")
rs.Open "SELECT * FROM bruger WHERE brugerId = " & Request.QueryString("Id"), conn, 2, 2
if Request.ServerVariables("REQUEST_METHOD") = "POST" then
'Opdaterer felterne
rs.update
rs("brugerkode") = Server.HTMLEncode(Request.QueryString("adgangskode"))
rs("brugerEjer") = Server.HTMLEncode(Request.QueryString("Ejer"))
rs("brugerAdresse") = Server.HTMLEncode(Request.QueryString("Adresse"))
rs("brugerPostnr") = Server.HTMLEncode(Request.QueryString("Postnr"))
rs("brugerBy") = Server.HTMLEncode(Request.QueryString("By"))
rs("brugerLand") = Server.HTMLEncode(Request.QueryString("Land"))
rs("brugerTelefon") = Server.HTMLEncode(Request.QueryString("Telefon"))
rs("brugeremail") = Server.HTMLEncode(Request.QueryString("email"))
rs("brugerHjemmeside") = Server.HTMLEncode(Request.QueryString("hjemmeside"))
rs.update
end if %>
<form method="post" action="login_admin.asp?mode=ejerprofil">
<table cellpadding="0" cellspacing="0" border="0" style="border-collapse: collapse" bordercolor="#111111" width="564">
<tr>
<td width="20" height="20"> </td>
<td height="25" colspan="2" width="262"><i><font face="Verdana" size="1">Du er logget ind som <%=rs("brugernavn")%></font></i></td>
<td height="25" width="282"> </td>
</tr>
<tr>
<td width="20" height="33" valign="top"> </td>
<td height="33" colspan="2" valign="top" width="262"><font class="small">
<b><font size="2">Ejer Profil</font></b></td>
<td height="33" valign="top" width="282"> </td>
</tr>
<tr>
<td width="20" height="20"> </td>
<td width="110" height="20"><font class="small">Oprettet</font></td>
<td height="20" width="152"><font class="small"><%=rs("brugerDato")%></font></td>
<td height="20" width="282"> </td>
</tr>
<tr>
<td width="20" height="20"> </td>
<td width="110" height="20"><font class="small">Brugernavn</font></td>
<td height="20" width="152"><font class="small"><%=rs("brugernavn")%></font> </td>
<td height="20" width="282"> </td>
</tr>
<tr>
<td width="20" height="20"> </td>
<td width="110" height="20"><font class="small">Adgangskode</font></td>
<td height="20" width="152">
<input type="text" name="adgangskode" value="<%=rs("brugerKode")%>" size="24" style="font-family: Verdana; font-size: 8 pt"></td>
<td height="20" width="282">
</td>
</tr>
<tr>
<td width="20" height="20"> </td>
<td width="110" height="20"><font class="small">Ejer</font></td>
<td height="20" width="152">
<input type="text" name="Ejer" value="<%=rs("brugerEjer")%>" size="24" style="font-family: Verdana; font-size: 8 pt"></td>
<td height="20" width="282">
</td>
</tr>
<tr>
<td width="20" height="20"> </td>
<td width="110" height="20"><font class="small">Adresse</font></td>
<td height="20" width="152">
<input type="text" name="Adresse" value="<%=rs("brugerAdresse")%>" size="24" style="font-family: Verdana; font-size: 8 pt"></td>
<td height="20" width="282">
</td>
</tr>
<tr>
<td width="20" height="20"> </td>
<td width="110" height="20"><font class="small">Postnr</font></td>
<td height="20" width="152">
<input type="text" name="Postnr" value="<%=rs("brugerPostnr")%>" size="24" style="font-family: Verdana; font-size: 8 pt"></td>
<td height="20" width="282">
</td>
</tr>
<tr>
<td width="20" height="20"> </td>
<td width="110" height="20"><font class="small">By</font></td>
<td height="20" width="152">
<input type="text" name="By" value="<%=Rs("brugerBy")%>" size="24" style="font-family: Verdana; font-size: 8 pt"></td>
<td height="20" width="282">
</td>
</tr>
<tr>
<td width="20" height="20"> </td>
<td width="110" height="20"><font class="small">Land</font></td>
<td height="20" width="152">
<input type="text" name="Land" value="<%=rs("brugerLand")%>" size="24" style="font-family: Verdana; font-size: 8 pt"></td>
<td height="20" width="282">
</td>
</tr>
<tr>
<td width="20" height="20"> </td>
<td width="110" height="20"><font class="small">Telefon</font></td>
<td height="20" width="152">
<input type="text" name="Telefon" value="<%=rs("brugerTelefon")%>" size="24" style="font-family: Verdana; font-size: 8 pt"></td>
<td height="20" width="282">
</td>
</tr>
<tr>
<td width="20" height="20"> </td>
<td width="110" height="20"><font class="small">E-mail</font></td>
<td height="20" width="152">
<input type="text" name="email" value="<%=rs("brugeremail")%>" size="24" style="font-family: Verdana; font-size: 8 pt"></td>
<td height="20" width="282">
</td>
</tr>
<tr>
<td width="20" height="20"> </td>
<td width="110" height="20"><font class="small">Hjemmeside</font></td>
<td height="20" width="152">
<input type="text" name="Hjemmeside" value="<%=rs("brugerHjemmeside")%>" size="24" style="font-family: Verdana; font-size: 8 pt"></td>
<td height="20" width="282">
(undlad venligst http://)</td>
</tr>
<tr>
<td width="20" height="10"></td>
<td width="110" height="10" style="border-left-width: 1; border-right-width: 1; border-top-width: 1; border-bottom: 1px solid #000000"></td>
<td height="10" style="border-left-width: 1; border-right-width: 1; border-top-width: 1; border-bottom: 1px solid #000000" width="152"></td>
<td height="10" width="282"></td>
</tr>
<tr>
<td width="20" height="10"></td>
<td width="110" height="10"></td>
<td height="10" width="152"></td>
<td height="10" width="282"></td>
</tr>
<tr>
<td width="20"> </td>
<td bordercolor="#ffffff" width="262" colspan="2">
<input type="submit" value="Gem Ændringer" id=submit1 name=submit1 style="font-family: Verdana; font-size: 8 pt"></td>
<td bordercolor="#ffffff" width="282">
</td>
</tr>
</table>
</form>
<% end if %>
