Data type mismatch in criteria expression.

EDEN · May 7th, 2006, 07:05 AM

I am trying to see information about a specific "host" (like hotel), I wanted to send "Host_Id" to a page which contains a form with all data about the host by its id, using this sentence:

Code:

response.write " / <a href='Mupdate_host.asp?Hid='" & rsHost.Fields("Host_Id") & "'>edit</a>"

Mupdate_host.asp code:

Code:

hostid=request.querystring("Hid")

SQLstring="Select * from tHosts where Host_Id='" & hostid & "'"
set rsHost=Server.CreateObject("ADODB.recordset")
rsHost.activeconnection=connection
rsHost.open SQLstring

"Host_Id" is an automatic number.

Now, when loading the page i get this error:

Code:

Microsoft JET Database Engine error '80040e07' 

Data type mismatch in criteria expression. 

/duckiee/ASP/Mupdate_host.asp, line 18

LINE 18: rsHost.open SQLstring

Thanks in advance.

P.S
If its the wrong forum im sorry :o(

gigaboy · November 22nd, 2006, 01:19 AM

try this
...where Host_Id = " & hostid

(take the literals out, that means youre trying to compare a string not a number)

ex
were string = 'string'
where number = number