适合男生创业十大行业:运行写入ACCESS数据库并提交写入信息时,出现INSERT INTO 语句的语法错误,不能把数据写入数据库?
来源:百度文库 编辑:查人人中国名人网 时间:2024/05/06 11:23:53
<%
set conn=server.createobject("adodb.connection")
DBPath = Server.MapPath("data/feedback.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
tmpmess=Server.HtmlEncode(request.form("comment"))
tmpmess=replace(tmpmess,chr(10)," <br>")
set rstmp=server.createobject("adodb.recordset")
set rstmp=conn.execute("Select * from feedbackinfo Where comment='"&trim(tmpmess)&"'")
if not rstmp.eof then
response.write("<p><font color=red style=""font:11pt"">错误:您重复提交了相同的反馈信息!</font><p><a href=javascript:history.back()>按此返回>></a>")
else
str="Insert Into feedbackinfo (name,money,tradecdf,gamexy,plait,salename,saleqq,buyname,gameser,mph,email,Color,Knowus,Way,bank,mess_date,mess_time,comment) values('"
str=str & request.form("name") & "','"
str=str & request.form("money") & "','"
str=str & request.form("tradecdf") & "','"
str=str & request.form("gamexy") & "','"
str=str & request.form("plait") & "','"
str=str & request.form("salename") & "','"
str=str & request.form("saleqq") & "','"
str=str & request.form("buyname") & "','"
str=str & request.form("gameser") & "','"
str=str & request.form("mph") & "','"
str=str & request.form("email") & "','"
str=str & request.form("Color") & "','"
str=str & request.form("Knowus") & "','"
str=str & request.form("Way") & "','"
str=str & request.form("bank") & "','"
str=str & cstr(DATE) & "','"
str=str & cstr(Time) & "','"
str=str & tmpmess & "')"
' Response.Write str
conn.execute(str)
set rs=server.createobject("adodb.recordset")
set rs=conn.execute("Select * from feedbackinfo Where comment='"&tmpmess&"'")
session.contents("comment")=tmpmess
%>
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/koocn/FEEDBACK.ASP, 第 36 行
上面是错误类型.高手加我的QQ吧38097630我在线.
set conn=server.createobject("adodb.connection")
DBPath = Server.MapPath("data/feedback.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
tmpmess=Server.HtmlEncode(request.form("comment"))
tmpmess=replace(tmpmess,chr(10)," <br>")
set rstmp=server.createobject("adodb.recordset")
set rstmp=conn.execute("Select * from feedbackinfo Where comment='"&trim(tmpmess)&"'")
if not rstmp.eof then
response.write("<p><font color=red style=""font:11pt"">错误:您重复提交了相同的反馈信息!</font><p><a href=javascript:history.back()>按此返回>></a>")
else
str="Insert Into feedbackinfo (name,money,tradecdf,gamexy,plait,salename,saleqq,buyname,gameser,mph,email,Color,Knowus,Way,bank,mess_date,mess_time,comment) values('"
str=str & request.form("name") & "','"
str=str & request.form("money") & "','"
str=str & request.form("tradecdf") & "','"
str=str & request.form("gamexy") & "','"
str=str & request.form("plait") & "','"
str=str & request.form("salename") & "','"
str=str & request.form("saleqq") & "','"
str=str & request.form("buyname") & "','"
str=str & request.form("gameser") & "','"
str=str & request.form("mph") & "','"
str=str & request.form("email") & "','"
str=str & request.form("Color") & "','"
str=str & request.form("Knowus") & "','"
str=str & request.form("Way") & "','"
str=str & request.form("bank") & "','"
str=str & cstr(DATE) & "','"
str=str & cstr(Time) & "','"
str=str & tmpmess & "')"
' Response.Write str
conn.execute(str)
set rs=server.createobject("adodb.recordset")
set rs=conn.execute("Select * from feedbackinfo Where comment='"&tmpmess&"'")
session.contents("comment")=tmpmess
%>
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/koocn/FEEDBACK.ASP, 第 36 行
上面是错误类型.高手加我的QQ吧38097630我在线.
呵呵,检查INSERT INTO语句
你先把时间那段去点先,然后再测试看是不是时间那段错误!
str=str & cstr(DATE) & "','"
str=str & cstr(Time) & "','"
你没有给出错误的详细描述很难给你查错,你用RESPONSE.WRITE的结果是不是跟你想要的一样,INSERT出错可能性最大的两种是列名和值的顺序及个数错误,还有就是表的数据类型定义跟值不一样
运行写入ACCESS数据库并提交写入信息时,出现INSERT INTO 语句的语法错误,不能把数据写入数据库?
运行写入ACCESS数据库并提交写入信息时,出现INSERT INTO 语句的语法错误,不能把数据写入数据库?
运行写入ACCESS数据库时,出现INSERT INTO 语句的语法错误,不能把数据写入数据库?
access突然不能写入数据库
关于对ACCESS数据库写入的问题
将本地文件信息写入远程服务器数据库
asp 操作access数据库时 不能进行写入操作
asp如何将当前时间写入access数据库中
asp怎样写入Access数据库这段代码对吗?
异地数据库同步,将信息能同时写入几个数据库