Syntax error (missing operator) in query expression 'Page_ID='.
Er der nogen af jer der kan fortælle mig hvorfor jeg får denne fejl??--------------------------------------------------
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'Page_ID='.
edit_login_ins.asp, line 30
--------------------------------------------------
Her er koden:
<%
Function TrimRep(strTekst)
strTekst = Trim(strTekst)
strTekst = Replace(strTekst,""",Chr(34))
strTekst = Replace(strTekst,"<br>",vbCrlf)
TrimRep = Replace(strTekst,"'","''")
End Function
if request.form("save") = "go" then
Brugernavn = TrimRep(request.form("Brugernavn"))
Password = TrimRep(request.form("Password"))
Page_ID = TrimRep(request.form("Page_ID"))
session("Brugernavn") = Replace(request.form("Brugernavn"),Chr(34),""")
session("Password") = Replace(request.form("Password"),Chr(34),""")
sql = "UPDATE login set Bruger_navn='" & Brugernavn & "', P_word='" & Password & "' WHERE Page_ID=" & Cint(Page_ID)
conn.execute(sql)
%>
<p class="mellemrubrik" align="center"><font size="3">Siden er opdateret!</font></p>
<span class="brodtxt">
<%
else
----------------------------FEJL--------------------------
sql = "SELECT * FROM login WHERE Page_ID=" & request.querystring("Page_ID")
set rs = conn.execute(sql)
----------------------------------------------------------
Brugernavn = Replace(rs("Brugernavn"),"""",""")
Password = Replace(rs("Password"),"""",""")
Brugernavn = Replace(Brugernavn,"<br>",vbCrLF)
Password = Replace(Password,"<br>",vbCrLF)
session("Brugernavn") = Brugernavn
session("Password") = Password
end if
%>
</span>
<form method="post" action="" class="brodtxt">
<span class="brodtxt">
<input type="hidden" name="save" value="go">
<input type="hidden" name="Page_ID" value="<%=request.querystring("Page_ID")%>">
</span>
<table border="0" width="301" align="center">
<tr>
<td class="brodtxt">
<p>Brugernavn</p>
<p>Password</p>
</td>
<td>
<div align="center"><span class="broed">
<input type="Bruger_navn" name="Brugernavn" class="input" maxlength="20" value="<%=session("Brugernavn")%>">
</span> </div>
<div align="center"><span class="broed">
<input type="password" name="Password" class="input" maxlength="20" value="<%=session("Password")%>">
</span> </div>
</td>
</tr>
<% end if %>
<tr>
<td class="brodtxt">
<CENTER>
</CENTER>
</td>
<td>
<div align="center"> <span class="brodtxt">
<input type=button class="brodtxt" value="<< Tilbage " onClick="history.go(-1)" name="button" >
<input type="submit" value="Gem ny tekst" class="brodtxt" onClick="history.go(-3)">
</span></div>
</td>
</tr>
</table>
</form>
<p class="brodtxt"> </p>
