手动扩孔工具:运行写入ACCESS数据库并提交写入信息时,出现INSERT INTO 语句的语法错误,不能把数据写入数据库?

来源:百度文库 编辑:高考问答 时间:2024/04/29 04:23:20
<%
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出错可能性最大的两种是列名和值的顺序及个数错误,还有就是表的数据类型定义跟值不一样