Question

错误号码-2147217913,标准表达式中数据类型不匹配ASP与ACCESS的错误

strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("0312ppp.mdb")

set conn = server.createobject("adodb.connection")

conn.open strconn

if Err.Number<>0 then
response.write "发生错误如下"
response.write "错误号码"&Err.Number&"<p>"
response.write "错误说明"&Err.Description&"<p>"
response.write "错误辅助说明"&err.helpcontext&"<p>"
response.write "错误说明路径"&err.helppath&"<p>"
response.write "原始错误"&err.nativeerror&"<p>"
response.write "错误来源"&err.source&"<p>"

end if

sub closeconn()
conn.close
set conn=nothing
end sub

birthday=trim(Request.Form("year"))&"-"&trim(Request.Form("month"))&"-"&trim(Request.Form("day"))
area=trim(replace(replace(replace(request.form("area"),"'",""),"[",""),"]",""))
love=trim(replace(replace(replace(request.form("love"),"'",""),"[",""),"]",""))
truename=trim(replace(replace(replace(request.form("truename"),"'",""),"[",""),"]",""))

on error resume next

conn.execute "update love_main set birthday='"&birthday&"',love='"&love&"',area='"&area&"',truename='"&truename&"',loveb=loveb"&loveb_jb_cx&" where id="&userid&""

if Err.Number<>0 then
response.write "发生错误如下"
response.write "错误号码"&Err.Number&"<p>"
response.write "错误说明"&Err.Description&"<p>"
response.write "错误辅助说明"&err.helpcontext&"<p>"
response.write "错误说明路径"&err.helppath&"<p>"
response.write "原始错误"&err.nativeerror&"<p>"
response.write "错误来源"&err.source&"<p>"

end if

if conn.errors.count<>0 then
response.write "发生连接错误"
for intcounter =0 to conn.errors.count
response.write "连接错误码;"&conn.errors(intcounter).number&"<p>"
response.write "连接错误说明:"&conn.errors(intcounter).description&"<p>"
next
end if

数据库表,ID 自动编号
BIRTHDAY 日期/时间
其他都是文本

Answer 1

什么啊