I am trying to create a personal phonebook. And I'd like to create a "canned" search page with a few cities (a field in the db called city) using checkboxes. It seems to work when one item is selected (Texas), but says nothing found when selecting two or more (Texas,California).

Any help would be greatly appreciated!

Right. At present, DBMan isn't set up to do "or" searches. I know that Alex is planning to add that to the next version of DBMan (but the release date is not yet known).

You can do an "or" search with a textfield, if you enter something like

Texas|California

and click the "Regular Expression" box in the search options.

------------------
JPD

Is there some sort of JavaScript I could use to change the submitted value of the checkboxes from val1~~val2~~val3 to val1|val2|val3 so that the search will work ? Or, perhaps I need to parse it in the cgi ?


Thanks!