Hi I'm not sure if i have posted this in the right place but i am having a lot of problems with on line of code with in my asp. I have connected an access database with a list of genres in a genres table (tblGenres) and then a products table (tblProducts) with the relationship of many products can have one genre and one genre to many products. I am now trying to make it so that when a user selects a genre on one page it will load another page with a list of all the products for that genre. the code that i am having particular trouble with is...
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "SELECT * FROM tblProducts WHERE tblProducts.GenreID = " & Request.QueryString("GenreID"), objConn
The error that keeps arising in the web browser is...
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.