|
|
<%
%>
<%
sq=request("sq")
if sq<>"" then sq=" and region like '%"&sq&"%'"
room_types=request("room_types")
if room_types<>"" then room_types=" and building_types like '%"&room_types&"%'"
price=trim(request("price"))
' response.write "the price value:"&price &"
"
if price<>"" then
select case price
case 3 price=" and (convert(float,price_rt)<3000) "
case 5 price=" and (convert(float,price_rt)>=3000 and convert(float,price_rt) <=5000)"
case 6 price=" and (convert(float,price_rt)>=5000 and convert(float,price_rt)<=6000)"
case 8 price=" and (convert(float,price_rt)>=6000 and convert(float,price_rt)<=8000)"
case 10 price=" and (convert(float,price_rt)>=8000 and convert(float,price_rt)<=10000)"
case 11 price=" and (convert(float,price_rt)>=10000)"
end select
end if
keyname=request.form("keyname")
if keyname="关键字" then keyname = ""
if keyname<>"" then keyname=" and (name like '%"&keyname&"%' or region like '%"&keyname&"%' or manager like '%"&keyname&"%' or address like '%"&keyname&"%' or pay_ways like '%"&keyname&"%' or seller_address like '%"&keyname&"%' or building_types like '%"&keyname&"%' or use_types like '%"&keyname&"%' or detail like '%"&keyname&"%')"
set rs=server.createobject("adodb.recordset")
sql="select name,file_name from new_floors where biaoji='show' and sign='"&cityid&"'"&sq&room_types&price&keyname&" order by dbo.fun_getPY(name),rec_time desc"
'response.write sql&"
"'
' response.end
rs.open sql,conn,1,1
i=0
ii=0
types2=""
biaoji=0
%>
|
|
