More Real Estate Searches

kpierson · Jul 22, 2000

I want to thank Potinenip for his questions on searching Real Estate and DM for his excellent answers. I need to take it one step farther. Right now a user enters price range, bedrooms, baths, and city. The output is great, no problems with that (code at bottom of message), but I also need to be able to have it sort by city alone, or price range or any combination of the above. Every time I tried a <CFIF> statement it just wouldn't work and stalled on the 'price'. Where do I go from here to be able to sort by one or more variables without having to input them all? <cfswitch expression="#form.searchprice#"> <CFCASE value="1"> <cfset low = 0> <cfset high = 9000000> </cfcase> <CFCASE value="2"> <cfset low = 1> <cfset high = 75000> </cfcase> <CFCASE value="3"> <cfset low = 75001> <cfset high = 100000> </cfcase> <CFCASE value="4"> <cfset low = 100001> <cfset high = 150000> </cfcase> <CFCASE value="5"> <cfset low = 150001> <cfset high = 200000> </cfcase> <CFCASE value="6"> <cfset low = 200001> <cfset high = 9000000> </cfcase> </cfswitch> <cfparam name="City" default=""> <cfparam name="bedrooms" default="0"> <cfparam name="bathrooms" default="0"> <CFQUERY Datasource="ronbrown" Name="homes"> Select * From resident  WHERE price between #low# and #high#       and Bedrooms >= #bedrooms#       and bathrooms = #bathrooms#       and city = '#city#'    order by price </CFQuery>

SnakeHollywood · Jul 23, 2000

Your order by needs to be comma delimited to order by several fields. order by price, baths, rooms You could have a select list on your form that allows multiple selections, which when submitted will give you your comma delimited list. order by #form.orderlist# Russ Michaels <a href=mailto:russ@satachi.com>russ@satachi.com</a> <a href=

http://www.satachi.com>Satachi

Internet Development</a> For my personal book recommendations visit

http://www.satachi.com/books.html

kpierson · Jul 23, 2000

Ok, did the above and added some <CFIF> statements and I am so close but... I still have to enter a price range. I can enter a price range and number of bedrooms, or price and city etc. but I just can't get it to work without entering a price. You can see the statement I have commented out below, that one doesn't work, it comes back and says it can not determine #low#. I am so close to where I want to be, but not there yet! Any help? <cfswitch expression="#form.searchprice#"> <CFCASE value="1"> <cfset low = 0> <cfset high = 9000000> </cfcase> <CFCASE value="2"> <cfset low = 1> <cfset high = 75000> </cfcase> <CFCASE value="3"> <cfset low = 75001> <cfset high = 100000> </cfcase> <CFCASE value="4"> <cfset low = 100001> <cfset high = 150000> </cfcase> <CFCASE value="5"> <cfset low = 150001> <cfset high = 200000> </cfcase> <CFCASE value="6"> <cfset low = 200001> <cfset high = 9000000> </cfcase> </cfswitch> <cfparam name="City" default=""> <cfparam name="bedrooms" default="0"> <cfparam name="bathrooms" default="0"> <CFQUERY Datasource="ronbrown1" Name="homes"> Select id, address, price, bedrooms, bathrooms, description, city, agent, email, picture From resident Where price between #low# and #high#        <cfif bedrooms is NOT "">   AND bedrooms = #form.bedrooms#   </cfif>   <CFIF bathrooms is NOT "">   AND bathrooms = #form.bathrooms#   </cfif>   <CFIF city is NOT "">   AND city = '#form.city#'   </cfif>       order by price </CFQuery>

DarkMan · Jul 24, 2000

On the form portion, you could do something like: Sort homes by:<select name="orderby"> <option value="price" selected>Price</option> <option value="city,price">City Then Price</option> <option value="bedrooms desc,price">Bedrooms and price</option> </select> Then on the action page: <cfparam name="City" default=""> <cfparam name="bedrooms" default="0"> <cfparam name="bathrooms" default="0"> <cfparam name="price" default="0"> <cfparam name="orderby" default="price"> <CFQUERY Datasource="ronbrown1" Name="homes"> Select id, address, price, bedrooms, bathrooms, description, city, agent, email, picture From resident Where 0=0   <CFIF price>      And price between #low# and #high#   </cfif>      <cfif bedrooms is NOT "">   AND bedrooms = #form.bedrooms#   </cfif>   <CFIF bathrooms is NOT "">   AND bathrooms = #form.bathrooms#   </cfif>   <CFIF city is NOT "">   AND city = '#form.city#'   </cfif>       order by #orderby# </CFQuery> Hope this helps...

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

More Real Estate Searches

kpierson

Technical User

SnakeHollywood

Programmer

kpierson

Technical User

DarkMan

Programmer

Similar threads

Part and Inventory Search

Sponsor