多条件查询语句

'selectid=request.form("select")

sql="select * from bazhu Where xz='出 售' or xz='求 购' "

 

if city<>"" then

    sql=sql&"And city like '%"&city&"%' "

End if

if house_type<>"" then

    sql=sql&"And house_type like '%"&house_type&"%' "

End if

if price_beg<>"" then

    sql=sql&"And price_beg like '%"&price_beg&"%' "

End if

if price_end<>"" then

    sql=sql&"And price_end like '%"&price_end&"%' "

End if

if living_room<>"" then

    sql=sql&"And living_room like '%"&living_room&"%' "

End if

if sitting_room<>"" then

    sql=sql&"And sitting_room like'%"&sitting_room&"%' "

End if

if toilet<>"" then

    sql=sql&"And toilet like'%"&toilet&"%' "

End if

 

 

 

 

sql=sql & "order by id desc"

set rs=server.createobject("ADODB.recordset")

 

'sql="select * from bazhu where xz='出 售' or xz='求 购'"

rs.open sql,conn,1,1

'end if

if rs.eof or rs.bof then

response.write "对不起，没有查询到您需要的内容！"

response.end

end if

rs.pagesize=20

if request.querystring("page")="" then

    rs.absolutepage=1

else

    rs.absolutepage=request.querystring("page")

end if

%>