Hent værdi id=1
Jeg har det her<%
tempConn = \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"db/alfred.mdb\") & \";UID=admin;PWD=;\"
Set myConn = Server.CreateObject(\"ADODB.Connection\")
strSQL = \"SELECT * FROM index where id = \'1\'\"
myConn.Open tempConn
Set rs = myConn.Execute(strSQL)
Response.Write rs(\"Side\")
myConn.Close
Set myConn = Nothing
%>
Jeg får denne fejl
Microsoft OLE DB Provider for ODBC Drivers error \'80040e07\'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
