Microsoft JET Database Engine '80040e14'
INSERT INTO 语句的语法错误。
user_add.asp, line 83
<%
if request("action")="add" then
if request.form("name")="" or request.form("password")=""then
response.write "<script language=javascript>"
response.write "alert('请输入完整信息');"
response.write "</script>"
response.write "<script language=javascript>location='javascript:history.back(1)'</script>"
Response.End
else
conn.Execute "insert into admin(name,password) values('"&request.form("name")&"','"&request.form("password")&"')"
response.write "<script language=javascript>"
response.write "alert('添加信息成功');"
response.write "</script>"
Response.Redirect("user_edit.asp")
end if
end if
%>
到底是哪里错了? 谢谢拉
參考答案:name,password是否为关键字加个[]试试
[name],[password]
