QuerySting i recordset
Har følgende querystring: test.asp?tlf=12345678og denne kode i mit recordset:
strSQL = "SELECT * FROM RMA WHERE (Telefon= " & Request.QueryString("tlf") & ") ORDER BY Telefon DESC "
Set rs = myConn.Execute(strSQL)
StrLINKS = strLINKS & rs("RMA-Nummer") & vbcrlf
response.write StrLinks
myConn.Close
Set myConn = Nothing
%>
Men hvorfor får jeg denne fejl: Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. ??
Den melder fejl i linjen "Set rs = myConn.Execute(strSQL)"