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:
response.write " / <a href='Mupdate_host.asp?Hid='" & rsHost.Fields("Host_Id") & "'>edit</a>"
SQLstring="Select * from tHosts where Host_Id='" & hostid & "'"
"Host_Id" is an automatic number.
Now, when loading the page i get this error:
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.
If its the wrong forum im sorry :o(