Newbies mbarnett Posted March 11, 2004 Newbies Share Posted March 11, 2004 My boss is trying to set up a property location search He wants to be able to search by 3 fields state from a pull down menu square footage from a pull down menu rate from pull down menu He has <SELECT NAME=state> <OPTION> <OPTION VALUE=GA>Georgia <OPTION VALUE=FL>Florida <OPTION VALUE=AL>Alabama <OPTION VALUE=VA>Virginia <OPTION VALUE=WV>West Virginia <OPTION VALUE=SC>South Carolina <OPTION VALUE=NC>North Carolina <OPTION VALUE=TN>Tennessee <OPTION VALUE=MS>Mississippi </SELECT><INPUT TYPE="hidden" NAME="-lop" VALUE=AND> for the state You can't seem to add <option value=>All States It returns no records found. The <option> leaves a blank line in the pull down but works. Anyway to set the All State value in the pull down for all three fields? Platform: Mac OS 9 Link to comment Share on other sites More sharing options...
jonesy17 Posted March 11, 2004 Share Posted March 11, 2004 I assume you're doing this through CDML? Try: <SELECT NAME=state> <OPTION VALUE="">ALL STATES <OPTION VALUE=GA>Georgia <OPTION VALUE=FL>Florida ... </SELECT> Link to comment Share on other sites More sharing options...
Newbies mbarnett Posted March 11, 2004 Author Newbies Share Posted March 11, 2004 All ready tried adding <OPTION VALUE="">ALL STATES but if does not work (No records found) Link to comment Share on other sites More sharing options...
Vaughan Posted March 12, 2004 Share Posted March 12, 2004 You need to create a calculation field in the database (I call it StateSearch) where State & " Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7322 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now