I'm trying to call a querystring "newsID" from a previous page to bring up a certain database record. However, I've been receiving this error "Data type mismatch in criteria expression" relating to my sql statement and I can't figure out why.

Here is what I have:

Dim conn, strSQL, rsNews

Set conn = Server.CreateObject("ADODB.Connection"
conn.open = MM_NewsDataBase_STRING

strSQL = "select * FROM tblnews " & _
"where ID =" & request.QueryString("newsID"

set rsNews = conn.Execute(strSQL)

The error keeps specifing a problem with the last line.
Can someone suggest what I'm doing wrong.

First try this:

strSQL = "select * FROM tblnews " & _
"where ID = " & request.QueryString("newsID" ' <--- Notice the extra space after the =

Then try this:

strSQL = "select * FROM tblnews " & _
"where ID = " & CInt(request.QueryString("newsID")


Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo