我这样写,哪里为什么不行啊?
<!--#include file="conn.asp"-->
<%
'c1092=request.form("c1092[]")
handset_no=request.form("handset_no")
password=request.form("password")
set rs_3=server.createobject("ADODB.Recordset")
sql_3="select * from userinfo where handset_no='"&request.form("handset_no")&"'"
rs_3.open sql_3,conn,1,3
if rs_3.eof then
response.write"<script>alert('您输入的手机号码还没有金华短信中心注册!');history.back();</script>"
response.end
end if
if password<>rs_3("password") then
response.write"<script>alert('您输入的密码不正确');history.back();</script>"
response.end
end if
set rs_1=server.createobject("ADODB.Recordset")
if request.form("c1092[]")="" and request.form("c1095[]")="" and request.form("c1094[]") and request.form("c4190[]") then
response.write"<script>alert('你选择要订阅的服务!');history.back();</script>"
response.end
end if
'sql_1="select * from "
for i=0 to ubound(info_serve)
new_code=info_serve(i)
set rs_2=server.createobject("ADODB.Recordset")
'response.write new_code
sql_2="select * from new_title where new_code='"&new_code&"'"
rs_2.open sql_2,conn,1,3
'if rs_2.eof then
' response.write"<script>alert('没有此栏目!');history.back();</script>"
'response.end
'end if
'xwdh=rs_2("xwdh")
'title=rs_2("title")
sql_1="select * from data_dizhi where handset_no='"&request.form("handset_no")&"'"
rs_1.open sql_1,conn,1,3
if rs_1.eof then
rs_1.addnew
rs_1("handset_no")=handset_no
rs_1("info_id")=rs_2("xwdh")
rs_1("new_code")=new_code
rs_1("title")=rs_2("title")
rs_1("info_data")=now
rs_1.update
rs_1.close
response.write"您已经成功订阅:"&title
end if
next
'response.write new_code