Microsoft OLE DB Provider for ODBC Drivers 錯誤 '80040e07'

分類: 電腦/網絡 >> 程序設計 >> 其他編程語言

問題描述:

[Microsoft][ODBC Microsoft Access Driver] 標準表達式中數據類型不匹配。

/softhy755b/zhongqiu/modi，行 36

'************update************

a_name = Request("name") '取得表單字體數據

a_id = Request("id")

a_name2= Request("name2")

a_from01= Request("from01")

a_oicq = Request("oicq")

a_memo = trim(Request("memo")) ' 取得留言內容

a_memo = Server.HTMLEncode(Request("memo"))

a_memo = Replace( a_memo, vbCrLf, "<br>")

a_memo = Replace( a_memo, "'", "''")

SQLcmd = "update wish set "

SQLcmd = SQLcmd & "name='" & a_name & "',memo='" & a_memo & "',name2='" & a_name2 & "',from01='" & a_from01 & "',oicq='" & a_oicq & "',addtime=now where id='" & a_id & "'"

response.write "<table width='100%' border=0 cellspacing=0 cellpadding=0 height='100%'><tr><td>"

response.write "<br><br><table width=250 border=1 cellspacing=2 cellpadding=2 align=center bordercolorlight=7285CF bordercolordark=7285CF height=90 bgcolor=F2F2F2>"

response.write "<tr bordercolor=F2F2F2 bgcolor=F2F2F2 align=center> "

response.write "<td>修改成功！</td>"

response.write "</tr>"

response.write "<tr bordercolor=F2F2F2 bgcolor=F2F2F2 align=center> "

response.write "<td>您修改的記錄已成功加入數據庫！</td>"

response.write "</tr>"

response.write "</table>"

35 response.write "</td></tr></table>"

36 newconn.Execute SQLcmd

管理員登入後修改留言出現這情況！！

請高手們解決，我是壹殼不通，非常感謝！！

解析: