长征精神与云南梦论文:asp高手进啊！！！

来源：百度文库编辑：高校问答时间：2024/04/30 19:03:43

<html>
<title>保存用户</title>
<head>
<%
dim sql,Vuser,Vpassword,Vpwdchk,Vcmpname,Vcmpaddress,Vphone,Vemail,Vpostalcode,Vnote
Vuser=request("user")
Vpassword=request("password")
Vpwdchk=request("pwdchk")
Vcmpname=request("cmpname")
Vcmpaddress=request("cmpaddress")
Vphone=request("phone")
Vemail=request("email")
Vpostalcode=request("postalcode")
Vnote=request("note")
set conn=server.CreateObject("adodb.connection")
cs="provider=microsoft.jet.oledb.4.0;data source="
conn.connectionstring=cs & server.MapPath("Conndb.mdb")
conn.open
set rsuser=conn.execute("select * from users where user='" & user & "'")
if not rsuser.eof then
%>
<script language="javascript">
alert("此用户名已存在，请另选一个用户名!");
history.go(-1);
</script>
<%
else
set rsuser=nothing
sql="INSERT INTO users(user,password,pwdchk,cmpname,cmpaddress,phone,email,postalcode,note)VALUES('" & Vuser & "','" & Vpassword & "','" & Vpwdchk & "','" & Vcmpname & "','" & Vcmpaddress & "','" & Vphone & "','" & Vemail & "','" & Vpostalcode & "','" & Vnote & "')"
conn.execute(sql)
end if
%>
</head>
</html>
错误类型：
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/user/UserSave.asp, 第 30 行
高手帮忙把这个问题解决一下啊！
谢谢！
我没有用中文标点，用的全部是英文标点，但是就是错误的！

sql="INSERT INTO users(user,password,pwdchk,cmpname,cmpaddress,phone,email,postalcode,note)VALUES('" & Vuser & "','" & Vpassword & "','" & Vpwdchk & "','" & Vcmpname & "','" & Vcmpaddress & "','" & Vphone & "','" & Vemail & "','" & Vpostalcode & "','" & Vnote & "') where (id is null)"

asp高手进啊！！！ asp高手进啊！！！关于ASP的问题？高手进啊 ASP高手进----------------》》》 asp代码高手进 Asp高手进 ASP高手进，帮个忙～～ ASP 高手进` ASP编程高手进！！ asp高手进！！！