Question

asp添加记录错误,请大家帮忙看一下~

add.asp

<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("data.mdb")
name=request.form("name")
card=request.form("card")
range=request.form("range")
address=request.form("address")
reason=request.form("reason")
money=request.form("money")
message=request.form("message")
exec="insert into disclose(name,card,range,address,reason,money,message)values('"+name+"','"+card+"','"+range+"','"+address+"','"+reason+"','"+money+"','"+message+"')"
conn.execute exec
conn.close
set conn=nothing
response.write "记录添加成功!"
response.redirect "index.asp"
%>

表单执行后提示如下:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/Disclose/add.asp, 第 12 行
改了一下,还是不行..还是不行,唉~~

Answer 1

修改为：
exec="insert into disclose([name],card,range,address,reason,money,message)values('"+name+"','"+card+"','"+range+"','"+address+"','"+reason+"','"+money+"','"+message+"')"

试试

Answer 2

exec="insert into disclose(name,card,range,address,reason,money,message)values('"+name+"','"+card+"','"+range+"','"+address+"','"+reason+"','"+money+"','"+message+"')"
改为
exec="insert into disclose(name,card,range,address,reason,money,message)values('"&name&"',"&card&",'"&range&"','"&address&"','"&reason&"','"&money&"','"&message&"')"

Answer 3

你的表名或者字段名是否与插入的数据相一致?
ODBC 是否连接到的是你的那个库呢