|
#2
沧声笑2011-11-13 16:05
|
asp代码
<%
set conn= Server.CreateObject("adodb.connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("ma.mdb")
na=request.form("na")
tel=request.Form("tel")
message=request.Form("message")
exec="INSERT INTO new(na,tel,message)values('"&na&"',"&tel&",'"&message&"')"
conn.execute exec
conn.close
set conn=nothing
response.Write "susscell"
%>
html代码
<body>
<form name="form1" action="reg1.asp" method="post">
na <input type="text" name="na" /><br />
tel <input type="text" name="text" /><br />
<input type="submit" name="Submit1" value="提交" />
<input type="submit" name="Submit2" value="重置" />
</form>
</body>
错误如下
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/reg1.asp, 第 8 行
conn.execute exec
这句是第八行的
找不出那错了，帮忙看看
[ 本帖最后由 沧声笑 于 2011-11-13 14:37 编辑 ]