Question

ASP插入记录出错怎么解决!

<%@language="vbscript"%>
<%
name=request.form("name")
mm=request.form("mm")
qrmm=request.form("qrmm")
if name="" or mm="" or qrmm="" then
response.redirect("zhuce.asp")
%>
<%else
set conn=server.createobject("adodb.connection")
conn.open "provider=microsoft.jet.oledb.4.0;data source=d:\06268\xue.mdb;"
set sql=conn.execute("insert into user (name,pass) values ('&name&','&mm&')")
set sql=nothing
conn.close
set conn=nothing
response.redirect("index.asp")
end if
%>

这段代码运行起来老是说

Microsoft JET Database Engine 错误 '80040e14'

INSERT INTO 语句的语法错误。

/zhuce2.asp，行 12
set sql=conn.execute("insert into user (name,pass) values ('"&name&"','"&mm&"')")

改成这样了也是错误的!55555
怎么办 怎么办

Answer 1

数据表名称错误，改为：
set sql=conn.execute("insert into [user] (name,pass) values ('"&name&"','"&mm&"')")

Answer 2

set sql=conn.execute("insert into user (name,pass) values ('&name&','&mm&')")
set sql=nothing
改成这样好看一点，不是select时可以不用set对像
sql = "insert into user (name,pass) values ('"&name&"','"&mm&"')"
conn.execute(sql)

Answer 3

set sql=conn.execute("insert into user (name,pass) values ('"&name&"','"&mm&"')") '看清变了那裏