<%
curname=request("name")
curname="家明鸽舍"
flag=request("flag")
if flag="" then
flag=1
end if
if flag=1 then
sql="select * from chengji where geshename='"&curname&"' and zhiyuan<>2 order by addyear desc,shunxu desc"
end if
if flag=2 then
sql="select * from chengji where geshename='"&curname&"' and zhiyuan=2 order by beizhiyuanren desc,addyear desc,shunxu desc"
end if
Set rs=Server.CreateObject("ADODB.Recordset")
Set rss=Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1
%>