Gossamer Forum
Home : Products : DBMan : Discussions :

Re: [otto99] Multiple returns for one field

Quote Reply
Re: [otto99] Multiple returns for one field In reply to
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/
Subject Author Views Date
Thread Multiple returns for one field otto99 8425 Jul 15, 2008, 10:07 AM
Thread Re: [otto99] Multiple returns for one field
LoisC 8284 Jul 20, 2008, 12:30 PM
Thread Re: [LoisC] Multiple returns for one field
otto99 8280 Jul 22, 2008, 6:42 AM
Post Re: [otto99] Multiple returns for one field
LoisC 8280 Jul 22, 2008, 8:50 AM