I've got a problem which I hope you can help me solve. I have some combo boxes that require a user to select values from. Depending on what was selected, I want a picture to be shown. First people need to select a country, then the site of the plant and then the person for which they want to see the data. It is at this point where I get into trouble. In the result asp page I have included this
and this is the code for get_picture.asp :
New Page 1
dim oconn, ors, strsql
ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/tel/database/tel_index.mdb")
set oconn = server.createobject("ADODB.connection")
set ors = server.createobject("ADODB.recordset")
id = request.querystring("personalID")
Response.buffer = true
strsql = "SELECT [picture] from picture WHERE personalID = '" & ID & "'order by personalID"
set ors = oconn.execute(strsql)
if not ors.eof then
set ors = nothing
set oconn = nothing
When I run the pages from the top, all that is shown is a box with a red X. When I run the get_picture.asp page I get following error :
0X80040E07 : data type mismatch in criteria expression.
What am I doing wrong ? The db contains a table picture, where you have 2 fields : personalID and picture.