博士生导师会带硕士吗:Microsoft JET Database Engine (0x80040E07) 标准表达式中数据类型不匹配。请指教!
来源:百度文库 编辑:神马品牌网 时间:2024/05/03 09:08:21
我在写updata数据库升级文件,进行数据库转换的时候出现如下错误,我搜索了一下,说是引号问题,可我仔细看了下,似乎引号没有问题啊,数字类型我没有加',而非数字类型,如 文本、备注我都加了'啊!
错误类型:
Microsoft JET Database Engine (0x80040E07)
标准表达式中数据类型不匹配。
/updata.asp, 第 188 行
网页:
GET /updata.asp
代码如下:
<%
set rslb=server.createobject("adodb.recordset")
if request("menu")="UserData" then
sqllb="select * from blog_Member order by mem_ID"
rslb.open sqllb,connlb,1,1
do while not rslb.eof
sqlaio="insert into blog_Member (mem_ID,mem_Name,mem_Password,mem_Sex,mem_Email,mem_HideEmail,mem_QQ,mem_HomePage,mem_Local,mem_RegTime,mem_LastIP,mem_Status,mem_PostLogs,mem_PostComms,mem_PostGBNums,mem_PostThreads,mem_PostPosts,mem_Intro,mem_Avatars) values ("&rslb("mem_ID")&",'"&rslb("mem_Name")&"','"&rslb("mem_Password")&"',"&rslb("mem_Sex")&",'"&rslb("mem_Email")&"','"&rslb("mem_HideEmail")&"','"&rslb("mem_QQ")&"','"&rslb("mem_HomePage")&"','"&rslb("mem_Local")&"','"&rslb("mem_RegTime")&"','"&rslb("mem_LastIP")&"','"&rslb("mem_Status")&"',"&rslb("mem_PostLogs")&","&rslb("mem_PostComms")&",0,0,0,'"&rslb("mem_Intro")&"','')"
Connaio.Execute(sqlaio)
rslb.movenext
loop
rslb.close
set rslb=nothing
response.write "<script>alert('用户数据表已全部转换完成,请继续其它表的转换');history.go(-1);</script>"
end if
我在 excute 下面加入以下代码进行调试,结果如下:
insert into blog_Member (mem_ID,mem_Name,mem_Password,mem_Sex,mem_Email,mem_HideEmail,mem_QQ,mem_HomePage,mem_Local,mem_RegTime,mem_LastIP,mem_Status,mem_PostLogs,mem_PostComms,mem_PostGBNums,mem_PostThreads,mem_PostPosts,mem_Intro,mem_Avatars) values (1,'admin','BBAD8D72C1FAC1D081727158807A8798',0,'','False','','','','2004-9-11 下午 10:17:09','218.90.236.90','Member',0,0,0,0,0,'','')
错误类型:
Microsoft JET Database Engine (0x80040E07)
标准表达式中数据类型不匹配。
/updata.asp, 第 188 行
网页:
GET /updata.asp
代码如下:
<%
set rslb=server.createobject("adodb.recordset")
if request("menu")="UserData" then
sqllb="select * from blog_Member order by mem_ID"
rslb.open sqllb,connlb,1,1
do while not rslb.eof
sqlaio="insert into blog_Member (mem_ID,mem_Name,mem_Password,mem_Sex,mem_Email,mem_HideEmail,mem_QQ,mem_HomePage,mem_Local,mem_RegTime,mem_LastIP,mem_Status,mem_PostLogs,mem_PostComms,mem_PostGBNums,mem_PostThreads,mem_PostPosts,mem_Intro,mem_Avatars) values ("&rslb("mem_ID")&",'"&rslb("mem_Name")&"','"&rslb("mem_Password")&"',"&rslb("mem_Sex")&",'"&rslb("mem_Email")&"','"&rslb("mem_HideEmail")&"','"&rslb("mem_QQ")&"','"&rslb("mem_HomePage")&"','"&rslb("mem_Local")&"','"&rslb("mem_RegTime")&"','"&rslb("mem_LastIP")&"','"&rslb("mem_Status")&"',"&rslb("mem_PostLogs")&","&rslb("mem_PostComms")&",0,0,0,'"&rslb("mem_Intro")&"','')"
Connaio.Execute(sqlaio)
rslb.movenext
loop
rslb.close
set rslb=nothing
response.write "<script>alert('用户数据表已全部转换完成,请继续其它表的转换');history.go(-1);</script>"
end if
我在 excute 下面加入以下代码进行调试,结果如下:
insert into blog_Member (mem_ID,mem_Name,mem_Password,mem_Sex,mem_Email,mem_HideEmail,mem_QQ,mem_HomePage,mem_Local,mem_RegTime,mem_LastIP,mem_Status,mem_PostLogs,mem_PostComms,mem_PostGBNums,mem_PostThreads,mem_PostPosts,mem_Intro,mem_Avatars) values (1,'admin','BBAD8D72C1FAC1D081727158807A8798',0,'','False','','','','2004-9-11 下午 10:17:09','218.90.236.90','Member',0,0,0,0,0,'','')
Microsoft JET Database Engine是什么?
Microsoft JET Database Engine是什么?
microsoft jet 4.0 service pack 8是什么?
Microsoft .Jet.OLEDB.4.0怎么下载安装?
Microsoft JET Database Engine (0x80004005)
Microsoft Jet 数据库引擎打不开文件 怎么办?
Microsoft JET Database Engine (0x80004005)
Microsoft JET Database Engine (0x80040E10)
Microsoft JET Database Engine (0x80040E14)
Microsoft JET Database Engine (0x80040E4D)