请哪位高手帮哈忙 (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> </p>
<p> </p>
<p> </p>
<p> </p>
<center>
<h1> 会员注册成功 </h1>
<p> <a href= "service6-1.asp "style= "color:#000000 &q