Try this and see if it works:
Search for A or B or E in a field
Question:
I have a field with 6 different possibilities: A, B, C, D, E, F.
How can I make a search where I can view all data corresponding to A or B or E in that field. So how can I search the db with an 'or' statement ?
Response:
Enter: A|B|E
in the search field on the form and check the ''Regular Expression'' checkbox. Or you can try adding a hidden field to your keyword search form:
<input type="hidden" name="re" value="on">
Otherwise also check out the DBMan FAQ thread called "Searching for Multiple Keywords" under searching.
Hope this helps
Unoffical DBMan FAQ
http://creativecomputingweb.com/dbman/index.shtml/
Search for A or B or E in a field
Question:
I have a field with 6 different possibilities: A, B, C, D, E, F.
How can I make a search where I can view all data corresponding to A or B or E in that field. So how can I search the db with an 'or' statement ?
Response:
Enter: A|B|E
in the search field on the form and check the ''Regular Expression'' checkbox. Or you can try adding a hidden field to your keyword search form:
<input type="hidden" name="re" value="on">
Otherwise also check out the DBMan FAQ thread called "Searching for Multiple Keywords" under searching.
Hope this helps
Unoffical DBMan FAQ
http://creativecomputingweb.com/dbman/index.shtml/