Problemer med SQL Select * FROM table WHERE
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.
- På dette script:
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../cgi-bin/db.mdb")
Conn.Open DSN
' SQL forespørgsel
strSQL = "Select * From musik Where ID = '" & Request.QueryString("id") & "'"
Set rs = Conn.Execute(strSQL)
