I'm stumped. I have a dropdown box for a range of dollar values ($0-$500, $501-$1000 etc.)in a dropdown box. Probably a mistake but I assigned each one a number value 1,2,3 etc. name is rugprice. I am at a loss how to search the data (rug) and show (price) of the rugs that fall within that range. The search page will have multiple ways to search (type, size and price). Any help on searching a range of numbers from a dropdown box would be appreciated.
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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search a dollar range 2
- Thread starter kpierson
- Start date
-
2
- #2
search.htm (cfm)<br>----------------<br><form action="searchres.cfm" method="post"><br><select name="rugprice"><br><option value=-1>please select</option><br><option value=1>$0-$500</option><br><option value=2>$501-$1000</option><br><option value=3>$1001-$1500</option><br></select><br><input type="submit"><br></form><br><br>searchres.cfm<br>-------------<br><cfswitch expression = "#form.rugprice#"><br><CFCASE value = "1"><br> <CFSET low = 0><br> <CFSET high = 500><br></cfcase><br><br><CFCASE value = "2"><br> <CFSET low = 501><br> <CFSET high = 1000><br></cfcase><br><br><CFCASE value = "3"><br> <CFSET low = 1001><br> <CFSET high = 1500><br></cfcase><br><br><!--- etc //---><br><br></cfswitch><br><br><CFQUERY name="search" datasource="your db"><br> select *<br> FROM tablename<br> WHERE rugprice between #low# and #high#<br></CFQUERY><br><br><CFOUTPUT QUERY="search"><br>#rugprice#<br><br></cfoutput><br><br>webron
- Thread starter
- #3
Thank you!!! That worked just great and was what I was needing. I am very impressed with the amount of help I have seen given on this site and the fact that the volume of message is just about the right size. Hate wading though 300 messages and that isn't even two days worth, would rather have fewer message that are of much higher quality.
- Status
Similar threads
- Locked
- Question