UC知道运行写入ACCESS数据库并提交写入信息时，出现INSERT INTO 语句的语法错误，不能把数据写入数据库？
来源：百度知道 编辑：UC知道 时间：2024/05/08 14:28:07
<%
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 &
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 &
呵呵,检查INSERT INTO语句
你先把时间那段去点先，然后再测试看是不是时间那段错误！
str=str & cstr(DATE) & "','"
str=str & cstr(Time) & "','"
你没有给出错误的详细描述很难给你查错，你用RESPONSE.WRITE的结果是不是跟你想要的一样，INSERT出错可能性最大的两种是列名和值的顺序及个数错误，还有就是表的数据类型定义跟值不一样