mrshlick

Its an include

No didnt work

Im trying to make links that will only bring up data form my database based on thier ID number. Im using microsoft Access and the database is called database.mdb, with the table Adaptors and the field ID which is set to autonumber. heres my code:<% Dim ID, conn, rs, dataSQLID = Request.QueryString ("ID")Set conn = Server.CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open(Server.Mappath("database\database.mdb"))Set rs = Server.CreateObject("ADODB.recordset")dataSQL = " SELECT * FROM Adaptor WHERE ID = '" & ID & "' "rs.Open dataSQL, connDo While Not rs.EOF%>and heres the browser error:Error Type:Microsoft JET Database Engine (0x80040E07)Data type mismatch in criteria expression./partswebsite/includes/adaptor.inc, line 10Line 10 is: rs.Open dataSQL, connThanks