using checkboxes with combination of search fields
8 posts by 3 authors in: Forums > CMS Builder
Last Post: September 9, 2008 (RSS)
By Deborah - September 9, 2008
What's happening for me is that when both checkboxes are selected, only those listings that contain a positive for both options are displayed, instead of an either/or.
It seems that checkboxes shouldn't be associated with each other in this manner. Does someone know of a way to accomplish what I'm trying to do?
Thanks in advance for any suggestions.
Re: [Deborah] using checkboxes with combination of search fields
By Donna - September 9, 2008
Thanks for your post. :)
At the moment, CMS Builder cannot do "or" searching. It's something we're looking into for the future, though. :)
--
support@interactivetools.com
Re: [Donna] using checkboxes with combination of search fields
By Deborah - September 9, 2008
Thanks for the prompt reply to my post (and for relieving me from the hours of time I've put into trying to figure this out on my own). [;)]
I'm disappointed to hear that this type of search isn't possible with the current version. This will require me to rethink my search setup for the real estate site I'm working on. I've worked with Realty Manager previously, where this type of search was available. I assumed CMS Builder would offer the same, but should have checked first.
This feature would get my vote for "top of list" for CMS Builder updates.
Thanks again.
Deborah
Re: [Deborah] using checkboxes with combination of search fields
By Donna - September 9, 2008
Actually... that sort of search wasn't available in Realty Manager, either. The search engines for both are pretty comparable. :)
--
support@interactivetools.com
Re: [Donna] using checkboxes with combination of search fields
By Deborah - September 9, 2008
That's odd. Maybe I didn't explain what it is I wanted to do very clearly. Here's a slice of the code I've used for a Realty Manager site I worked with, which does seem to return results for two checkboxes, if two are selected.
<input type="checkbox" name="lfield18_keyword" value="Yes">Ocean View
<input type="checkbox" name="lfield19_keyword" value="Yes" />Lake View
<input type="checkbox" name="lfield20_keyword" value="Yes" />Mountain View
Without the ability to choose more than one checkbox at a time, the site visitor would have to return to the search form and view the results separately for Ocean View and Lake View, where they might like to view the combined results.
I'm hoping you're going to say something like... "oh, so that's what you want to do... here's how...!"
Deborah
Re: [Deborah] using checkboxes with combination of search fields
By Donna - September 9, 2008
That works the same as CMS Builder -- if both "Ocean View" and "Lake View" were checked, only listings that had both "Ocean View" and "Lake View" would come back. Both Listings Manager & CMS Builder only do "and" searches, not "or".
Adding boolean searches is a pretty big endeavor... but it's definitely a requested feature. :)
--
support@interactivetools.com
Re: [Donna] using checkboxes with combination of search fields
By Deborah - September 9, 2008
I just went back to the Realty Manager site I worked on several years ago and performed some searches. And I'm embarrased to say that you are so right! [blush]
Thanks so much for clearing that up. I'll figure out a plan from here for the new project. (And I'm open to any suggestions.)
Deborah
Re: [Deborah] using checkboxes with combination of search fields
By Dave - September 9, 2008
We could probably make it work with a small amount of custom programming. Email me direct (dave@interactivetools.com) with a mockup of the search form and I can let you know how involved it would be.
Basically we just need to create a custom MySQL query based on the form input. You can do just about anything with SQL queries.
Hope that helps!
interactivetools.com