奶嘴男故事会:帮帮修改asp代码

<!--#INCLUDE FILE="sysinc.asp" -->
<%
pro1=request.form("pro1")
num1=request.form("num1")
pro2=request.form("pro2")
num2=request.form("num2")
pro3=request.form("pro3")
num3=request.form("num3")
username=request.form("username")
sex=request.form("sex")
tel=request.form("tel")
fax=request.form("fax")
email=request.form("email")
address=request.form("address")
yzbm=request.form("yzbm")
backriqi=request.form("backriqi")
qq=request.form("qq")
company=request.form("company")
sendmethod=request.form("sendmethod")
paymethod=request.form("paymethod")
detail=request.form("detail")
if username<>"" and company<>"" then

SQL="insert into purchase

(pro1,num1,pro2,num2,pro3,num3,username,sex,tel,fax,email,address,yzbm,backriqi,qq,company,sendmethod,paymethod,detail)

values

("sql=sql&"'"&pro1&"',"sql=sql&"'"&num1&"',"sql=sql&"'"&pro2&"',"sql=sql&"'"&num2&"',"sql=sql&"'"&pro3&"',"sql=sql&"'"&num3&"

',"sql=sql&"'"&username&"',"sql=sql&"'"&sex&"',"sql=sql&"'"&tel&"',"sql=sql&"'"&fax&"',"sql=sql&"'"&email&"',"sql=sql&"'"&add

ress&"',"sql=sql&"'"&yzbm&"',"sql=sql&"'"&qq&"',"sql=sql&"'"&company&"',"sql=sql&"'"&sendmethod&"',"sql=sql&"'"&paymethod&"',

"sql=sql&"'"&detail&"')"
conn.execute sql
conn.close
set conn=nothing
response.write "记录添加成功!"
else
response.write "公告信息不全 请确定！！"
end if
response.redirect"index5.asp"
%>