new to asp... can't figure out update
Wow. This has gotten extremely frustrating. I cannot for the life of me figure out how to use ASP. At least to update...
here is the code I'm using (and I'm only trying to update one field!)
id = Request.Form("id")
update_sql = "UPDATE tblApartment SET"
IF len(Request.Form("status")) THEN
update_sql = update_sql & " Status = '" & _
Request.Form("status") & "'"
'Set the where clause
update_sql = update_sql & " WHERE ID = '" & _
id & "'"
Set connect = Server.CreateObject("ADODB.connection")
Set output = Server.CreateObject("ADODB.Recordset")
output.Open update_sql, connect
Response.Write "<hr noshade>The following insert string was executed "
set connect = Nothing
And here is the error
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
If you can offer up any help... PLEASE DO!
I'm pulling out hairs here
Hope you are having a good day.