28,404
社区成员
发帖
与我相关
我的任务
分享<!--#include file="conn.asp"-->
<%
Dim arrTmp()
Redim arrTmp(100)
Gender1=request.Form("Gender")
age1=request.Form("age1")
age2=request.Form("age2")
country=request.Form("which country")
set rs=server.createobject("adodb.recordset")
sql="select Username,Gender,age,Country from customer1 where Gender='"&Gender1&"'and(age BETWEEN '"&age1&"' and '"&age2&"')and Country ='"&country&"'"
rs.open sql,conn,1,1
if rs.eof and rs.bof then '记录不存在,说明email输入错误
response.Write("email is wrong!")
else'否则执行下面语句
for (i=0 to rs.recordcount)
'response.Write(""&rs("Username")&"")=arrTmp
arrTmp(i)=rs("Username")
rs.MoveNext
next
end if
rs.close
conn.close
session("aaaa")=arrTmp
Set rs = Nothing
Set Conn = Nothing
%>