I was wondering if there's a way to set multiple searches for the same field. We have a database containing case numbers, dates, and results of a review of the case numbers. This is all working, one at a time, quite nicely in dbman, but I would like to have the user get more than one result if they choose. Can this be done? I searched the archives but didn't find exactly what I'm wanting. Thanks in advance.
Jul 20, 2008, 12:30 PM
Veteran / Moderator (3034 posts)
Jul 20, 2008, 12:30 PM
Post #2 of 4
Views: 8290
I'm not sure exactly what you're looking for. Are you using a custom search form where the users search within specific fields or using a keyword search form?
Have you by any chance looked in the DBMan FAQ ... linked in signature?
Unoffical DBMan FAQ
http://creativecomputingweb.com/dbman/index.shtml/
Have you by any chance looked in the DBMan FAQ ... linked in signature?
Unoffical DBMan FAQ
http://creativecomputingweb.com/dbman/index.shtml/
Jul 22, 2008, 6:42 AM
New User (2 posts)
Jul 22, 2008, 6:42 AM
Post #3 of 4
Views: 8286
Yes, I looked there, and the closest thing I can find is in the Search section, #83 (more about which below). However, I am learning this on the fly, so I may not have been clear about what I want. Let me try again.
I have a search box for a field called case_number. The user puts the number in and gets a response on the status of that case's review, and the date of the status change, if any. Now, this all works great if you enter one number at a time, and the grand potentates are pleased. However, I would like to add the ability to search more than one case number at a time, say 5 numbers are entered and 5 responses are generated, which would please the potentates even more, with obvious personal benefits. The FAQ item #83 confused me because that string has specific numbers for the search, and I'm not sure where the string goes anyway. Thank you for your assistance and patience with a rank noob.
I have a search box for a field called case_number. The user puts the number in and gets a response on the status of that case's review, and the date of the status change, if any. Now, this all works great if you enter one number at a time, and the grand potentates are pleased. However, I would like to add the ability to search more than one case number at a time, say 5 numbers are entered and 5 responses are generated, which would please the potentates even more, with obvious personal benefits. The FAQ item #83 confused me because that string has specific numbers for the search, and I'm not sure where the string goes anyway. Thank you for your assistance and patience with a rank noob.
Jul 22, 2008, 8:50 AM
Veteran / Moderator (3034 posts)
Jul 22, 2008, 8:50 AM
Post #4 of 4
Views: 8286
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/