Hi there,
I've set up a Multiple Select list box for picking from one or more of the 50 states, but with one problem.
The *administration* end works great--ie, you can add or modify entries to show up under multiple states.
However, when running a search, you can only choose one state--if you try more than one (even with "Match Any" checked) it gives a "no records found" error.
For instance, if an entry includes all 50 states, and you choose Michigan, it will work properly, but if you search for Michigan *and* Vermont, it will give a "no records found" error.
Any hints?
Here's the front-end URL:
http://compreplan.com/cgi/dbman/db.cgi?db=default&uid=default&view_search=1
I've set up a Multiple Select list box for picking from one or more of the 50 states, but with one problem.
The *administration* end works great--ie, you can add or modify entries to show up under multiple states.
However, when running a search, you can only choose one state--if you try more than one (even with "Match Any" checked) it gives a "no records found" error.
For instance, if an entry includes all 50 states, and you choose Michigan, it will work properly, but if you search for Michigan *and* Vermont, it will give a "no records found" error.
Any hints?
Here's the front-end URL:
http://compreplan.com/cgi/dbman/db.cgi?db=default&uid=default&view_search=1