using checkboxes with combination of search fields

Hi Deborah,

Thanks for your post. :)

At the moment, CMS Builder cannot do "or" searching. It's something we're looking into for the future, though. :)

Donna,

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

Hi Deborah,

Actually... that sort of search wasn't available in Realty Manager, either. The search engines for both are pretty comparable. :)

Donna,

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

Hi Deborah,

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. :)

Donna,

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

Hi Deborah,

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!