hvad går der galt her?
hvorfor får jeg den her fejl?Fejltype:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access-driver] Datatyperne stemmer ikke overens i kriterieudtrykket.
/reg/opdater_bruger.asp, line 8
koden kommer her:
<%@ Language=\"VBSCRIPT\" %>
<% Response.buffer = True %>
<%
ting = Request.Form(\"id\")
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\\Inetpub\\db\\register.mdb\"
SQL = \"UPDATE brugere set brugernavn=\'\"& Request.Form(\"brugernavn\") & \"\',kodeord=\'\" & Request.Form(\"kodeord\") &\"\',niveau=\'\"& Request.Form(\"niveau\") & \"\',navn=\'\"& Request.Form(\"navn\") &\"\',tlfnr=\'\"& Request.Form(\"tlfnr\") &\"\',email=\'\"& Request.Form(\"email\") & \"\' WHERE brugerid = \'\" & ting & \"\'\"
set rs = Conn.Execute(SQL)
Conn.Close
Set Conn = Nothing
\'Response.Redirect(\"overskrifter.asp\")
%>
<HTML>
<head>
<title>opdater bruger</title>
<link rel=\"stylesheet\" href=\"register.css\">
</head>
<BODY bgcolor=\"#7795A5\" class=\"text\">
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"500\">
<tr>
<td class=\"text\">
<b>
<a href=\"login.asp\" alt=\"login\">LOGIN</a>
|
<a href=\"ordre.asp\" alt=\"ordrer\">ORDRER</a>
|
<a href=\"kunder.asp\" alt=\"kunder\">KUNDER</a>
|
<a href=\"ny_reg.asp\" alt=\"registrering\">REGISTRERING</a>
|
<a href=\"rapport.asp\" alt=\"rapporter\">RAPPORTER</a>
|
<a href=\"soeg.asp\" alt=\"Søgning\">SØG</a>
|
<a href=\"admin.asp\" alt=\"adminzone\">ADMIN</a>
</b>
</td>
</tr>
</table>
<br>
<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">
<tr><td class=\"text\">
<b>
Brugeren <%=request.form(\"brugernavn\") %> er nu opdateret !
<br>
klik <a href=\"admin.asp\">her</a> for at komme tilbage til <a href=\"admin.asp\">admin zone</a>.
</b>
</td></tr>
</table>
</BODY>
</HTML>
og her kommer koden til den side som dataen komlmer fra:
<!--#include file=\"protect.inc\"-->
<%
brug = Request.form(\"brugernavn\")
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=E:\\Inetpub\\db\\register.mdb\"
SQL = \"SELECT * FROM brugere WHERE brugerid = \"&brug
set rs = Conn.Execute(SQL)
id = rs(\"brugerid\")
bruger = rs(\"brugernavn\")
kode = rs(\"kodeord\")
niv = rs(\"niveau\")
navn = rs(\"navn\")
tlf = rs(\"tlfnr\")
mail = rs(\"email\")
%>
<HTML>
<head>
<title>opdater bruger</title>
<link rel=\"stylesheet\" href=\"register.css\">
</head>
<BODY bgcolor=\"#7795A5\" class=\"text\">
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"500\">
<tr>
<td class=\"text\">
<b>
<a href=\"login.asp\" alt=\"login\">LOGIN</a>
|
<a href=\"ordre.asp\" alt=\"ordrer\">ORDRER</a>
|
<a href=\"kunder.asp\" alt=\"kunder\">KUNDER</a>
|
<a href=\"ny_reg.asp\" alt=\"registrering\">REGISTRERING</a>
|
<a href=\"rapport.asp\" alt=\"rapporter\">RAPPORTER</a>
|
<a href=\"soeg.asp\" alt=\"Søgning\">SØG</a>
|
<a href=\"admin.asp\" alt=\"adminzone\">ADMIN</a>
</b>
</td>
</tr>
</table>
<br>
<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">
<tr>
<td class=\"text\">
<b><font size=\"2\">Opdater Bruger</font></b></td></tr>
<tr><td class=\"text\">
<FORM METHOD=\"POST\" ACTION=\"opdater_bruger.asp\">
<input type=\"hidden\" value=\"<%=id %>\" name=\"brugerid\"><br>
<b>Brugernavn:<br>
<input type=\"text\" name=\"brugernavn\" value=\"<%=bruger %>\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\">
<br><br>
Kodeord:<br>
<input type=\"text\" name=\"kodeord\" value=\"<%=kode %>\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\">
<br><br>
Brugerniveau:<br>
<INPUT TYPE=\"text\" NAME=\"niveau\" value=\"<%=niv %>\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\">
<br><br>
Navn:<br>
<input type=\"text\" name=\"navn\" value=\"<%=navn %>\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\">
<br><br>
Telefonummer:<br>
<input type=\"text\" name=\"tlfnr\" value=\"<%=tlf %>\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\">
<br><br>
Emailadresse:<br>
<input type=\"text\" name=\"email\" value=\"<%=mail %>\" size=\"15\" class=\"formsearchsmall\" style=\"width: 180px\">
<BR><br><br>
</b>
<INPUT TYPE=SUBMIT VALUE=\"Opret\" class=\"formbutton\">
<input type=\"reset\" value=\"slet\" class=\"formbutton\">
</FORM>
</td></tr>
</table>
</BODY>
</HTML>
<%
Conn.Close()
Set Conn = nothing
%>
