日期:2014-05-17  浏览次数:20987 次

请哪位高手帮哈忙 (0x80040E14)INSERT INTO 语句的语法错误。
技术信息(用于支持人员)

错误类型:
Microsoft   JET   Database   Engine   (0x80040E14)
INSERT   INTO   语句的语法错误。
/sanatorium/service/buy1/conn.asp,   第   41   行


浏览器类型:
Mozilla/4.0   (compatible;   MSIE   6.0;   Windows   NT   5.1;   SV1;   .NET   CLR   2.0.50727)  

网页:
POST   290   ???   /sanatorium/service/buy1/addreg_success.asp

addreg_success.asp代码如下:
<%@LANGUAGE= "VBSCRIPT "   CODEPAGE= "936 "%>

<!--   #Include   File=conn.asp   -->
<!--   #Include   File=../../admin/md5.asp   -->
<%
username=md5(request.form( "username "))
password=md5(request.form( "password "))
realname=request.form( "realname ")
'superadmin=request.form( "superadmin ")
address=request.form( "address ")
usertel=request.form( "usertel ")
mobile=request.form( "mobile ")
useremail=request.form( "useremail ")
recepit=request.form( "recepit ")
sex=request.form( "sex ")
postcode=request.form( "postcode ")
city=request.form( "city ")
if   username= " "   or   password= " "   or   realname= " "   or   address= " "   or   usertel= " "   or   mobile= " "   or   recepit= " "   or   sex= " "   or   postcode= " "   or   city= " "   then
response.write   " <script> alert( '用户资料请填写清楚 '); </script> "
response.write   " <script> history.go(-1); </script> "
response.end
end   if

addrs   "member ", "username,password,recepit,address,usertel,mobile,useremail,sex,postcode,city ", " ' "+username+ " ', ' "+password+ " ', ' "+realname+ " ', ' "+address+ " ', ' "+usertel+ " ', ' "+mobile+ " ', ' "+useremail+ " ', ' "+recepit+ " ', ' "+sex+ " ', ' "+postcode+ " ', ' "+city+ " ' "   '添加数据

closeconn()
%>
<HTML>
<HEAD>
<TITLE> 操作成功 </TITLE>
<meta   name= "Generator "   content= "EditPlus ">
<meta   name= "Author ">
<meta   name= "Keywords "   content= " ">
<meta   name= "Description "   content= " ">
<link   href= "../buy/css/index_style.css "   rel= "stylesheet "   type= "text/css ">
<meta   http-equiv= "Content-Type "   content= "text/html;   charset=gb2312 ">
<link   href= "../../css/index_style.css "   rel= "stylesheet "   type= "text/css ">
</HEAD>

<BODY>
<p> &nbsp; </p>
<p> &nbsp; </p>
<p> &nbsp; </p>
<p> &nbsp; </p>
<center>
    <h1> 会员注册成功 </h1>
        <p> <a   href= "service6-1.asp "style= "color:#000000 &q