Problem med at se poster i databasen
Jeg kan ikke få lov til at se posterne. Jeg får denne meddelse. Microsoft OLE DB Provider for ODBC Drivers error '80040e07'[Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in criteria expression.
fejlen er i denne linie Set Rs=MinConn.Execute(MinSQL)
<!-- Created: 02-02-00 10:28:52 -->
<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
<META HTTP-EQUIV="Content-Type"CONTENT="text/html;CHARSET=iso-8859-1">
<TITLE>Untitled</TITLE>
</HEAD>
<BODY>
<%
DIM nummer
nummer=Trim(request("nummer"))
Set MinConn=Server.CreateObject("ADODB.Connection")
MinConn.Open "PROVIDER=MSDASQL;" & _
"DRIVER={Microsoft Access Driver (*.mdb)}; " & _
"DBQ=" & server.mappath("lod.mdb")
MinSQL="Select * from lod where nummer='" & nummer & "'"
Set Rs=Server.CreateObject("ADODB.RecordSet")
Set Rs=MinConn.Execute(MinSQL)
%>
<TABLE width="387">
<TR>
<TD width="203" align="center"><B>fornavn</B></TD><TD width="116" align="center"><B>efternavn</B></TD><TD width="48" align="center"><B>nickname</B></TD><TD width="48" align="center"><B>map</B></TD><TD width="48" align="center"><B>vaben</B></TD><TD width="48" align="center"><B>ICQ</B></TD><TD width="48" align="center"><B>mobil</B></TD><TD width="48" align="center"><B>motto</B></TD>
</TR>
<%
Do while not Rs.EOF%>
<TR>
<TD width="203"><%=Rs("fornavn")%></TD>
<TD width="116"><%=Rs("efternavn")%></TD>
<TD width="48"><%=Rs("nickname")%></TD>
<TD width="48"><%=Rs("map")%></TD>
<TD width="48"><%=Rs("vaben")%></TD>
<TD width="48"><%=Rs("ICQ")%></TD>
<TD width="48"><%=Rs("Mobil")%></TD>
<TD width="48"><%=Rs("Motto")%></TD>
</TR>
<%
Rs.MoveNext
Loop%>
</TABLE>
<%
Rs.close
Set Rs= Nothing
MinConn.Close
set MinConn=nothing%>
<A HREF="menu.inc">Tilbage i menu</A>
</BODY>
</HTML>
