Data type mismatch error...can't solve this

[snowboardr]

Not sure why im getting this!
------------------------------

Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/duck/Default.asp, line 564 ---> rs = my_conn.Execute(StrSQL)

<%
ConnString = &quot;Provider=Microsoft.Jet.OLEDB.4.0; Data Source=&quot; & Server.MapPath(&quot;database.mdb&quot;)

set my_conn= Server.CreateObject(&quot;ADODB.Connection&quot;)
set rs = Server.CreateObject(&quot;ADODB.RecordSet&quot;)

my_conn.Open ConnString

Smid = Request.Querystring(&quot;mID&quot;)

StrSQL = &quot;SELECT * FROM specs WHERE mID=&quot; & &quot;'&quot; & Smid & &quot;'&quot;

rs = my_conn.Execute(StrSQL)

model_name = rs(&quot;model_name&quot;)

Response.Write(model_name)
%>

 

[JuanitaC]

Is the data type for mID numeric or varchar?

If it is numeric, don't use single quotes around the value.

The easiest way to debug SQL statements is to write them to the screen, then run them in your database program... you sometimes get more useful error messages there.