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

来源:百度知道 编辑:UC知道 时间:2024/09/21 20:17:25
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"
%>

表单执行后提示如下:
<

修改为:
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+"')"
改为
exec="insert into disclose(name,card,range,address,reason,money,message)values('"&name&"',"&card&",'"&range&"','"&address&"','"&reason&"','"&money&"','"&message&"')"

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