hvad kan der være galt her?
jeg bliver ved med at få den her fejlFejltype:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access-driver] Datatyperne stemmer ikke overens i kriterieudtrykket.
/reg/vis_kunde.asp, line 9
Browsertype:
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Side:
POST 7 bytes to /reg/vis_kunde.asp
POST Data:
kunde=1
her er koden og det skal lige nævnes at alle felter i basen enten er tekst eller notat
<%@ Language=\"VBSCRIPT\" %>
<% Response.buffer = True %>
<!--#include file=\"protect.inc\"-->
<%
kunid = Request.form(\"kunde\")
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\\Inetpub\\db\\register.mdb\"
SQL = \"SELECT * FROM kunder WHERE kundenr = \"&kunid
set rs = Conn.Execute(SQL)
%>
<html>
<head>
<title>kundeinfo</title>
<link rel=\"stylesheet\" href=\"register.css\">
</head>
<body bgcolor=\"#7795A5\">
<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=\"admin.asp\" alt=\"adminzone\">ADMIN</a>
</b>
</td>
</tr>
</table>
<br>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"350\">
<tr>
<td class=\"text\" width=\"350\">
<font size=\"2\"><b>Kunde:</font><font size=\"2\" color=\"red\">
<%
response.write rs(\"firmanavn\")
%>
</font></b>
</td>
</tr>
<tr>
<td class=\"text\" width=\"350\">
<%
response.write \"<b>Kundenummer:</b><br>\"
response.write rs(\"kundenr\")
response.write \"<br><b>Gade:</b><br>\"
response.write rs(\"gade\")
response.write \"<br><b>Postnummer:</b><br>\"
response.write rs(\"postnr\")
response.write \"<br><b>By:</b><br>\"
response.write rs(\"by\")
response.write \"<br><b>Telefonnummer:</b><br>\"
response.write rs(\"tlfnr\")
response.write \"<br><b>Faxnummer:</b><br>\"
response.write rs(\"faxnr\")
response.write \"<br><b>Emailadresse:</b><br>\"
response.write rs(\"email\")
response.write \"<br><b>Kontaktperson:</b><br>\"
response.write rs(\"kontaktperson\")
response.write \"<br><b>kontaktpersons mobilnummer:</b><br>\"
response.write rs(\"kontaktpmobil\")
%>
</b>
</td>
</tr>
</table>
</body>
</html>
<%
Conn.Close()
Set Conn = nothing
%>
