# ASP : mismatch?

**URL:** https://forum.kirupa.com/t/asp-mismatch/85795
**Category:** programming
**Created:** [April 7, 2005, 3:47pm UTC](https://forum.kirupa.com/t/asp-mismatch/85795 "2005-04-07T15:47:07Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![dinkumrocks](https://avatars.discourse-cdn.com/v4/letter/d/7feea3/32.png) [@dinkumrocks](https://forum.kirupa.com/u/dinkumrocks)
#### Post date: [April 7, 2005, 3:47pm UTC](https://forum.kirupa.com/t/asp-mismatch/85795/1 "2005-04-07T15:47:07Z")

</div>

Ok.

through my whole “journey” of building my web app with asp, you guys have answered my question. i wanna say thanks.

but i have another question, and ill prolly have more.

OK. i get this error…

```auto
 
 
 
Microsoft OLE DB Provider for ODBC Drivers[font=Arial][size=2]error '80040e07'[/size][/font]
 
[font=Arial][size=2][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.[/size][/font] [font=Arial][size=2]/community/news_comment.asp[/size][/font][font=Arial][size=2], line 47[/size][/font] 
 

```

and this is the code that causes the error.

```auto
 <%set RScomments = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM comments WHERE storyid=" & Request.QueryString("storyid") & ""
RScomments.Open strSQL, Conn
RScomments.MoveFirst()
If not RScomments.eof then
while Not RScomments.eof
%>
	<div class="asset"><span class="newstitle"><%= RScomments("item_title")%></span>
	<br><%= RScomments("item_when")%> <strong>- by</strong> <%= RScomments("item_user")%><br><br>
	<%= RScomments("item_body")%></div>
		 </div>
	 <%RScomments.movenext
wend
else 
Response.write "There are no comments right now."
end if
%> 

```

line 47 is where the recordset is opened.

i dont know whats causing this error, tahts why i came here 🙂

Edit:// the querysting “storyid” _is_ an integer, just incase you were wondering 🙂

Thanks for anyhelp,  
-Naaman