% q="select * from data where 1=1 " if request("Hotel name") <> "" then q=q & " and [hotel name]='" & request("hotel name") &"' " end if if request("city")<> "" then q=q & " and city='" & request("city") &"' " end if if request("state")<> "" then q=q & " and state='" & request("state") &"' " end if if request("category")<> "" then q=q & " and category='" & request("category") &"' " end if set rs=conn.execute(q) %>
![]() |
![]() |
| <%'%> |
Search Results
|
<%'%> | ||||||||||||