Gossamer Forum
Home : Products : DBMan : Customization :

Entering more than one term in a field

Quote Reply
Entering more than one term in a field
If I have a field called "name" and I want to do and/or searches (especially or) in that field ("smith or jones") where would be the best place to modify my dbman? Perhaps there is already a mod to do this.
Thanks.
Tony.
Quote Reply
Re: [tbalazs] Entering more than one term in a field In reply to
Check out the FAQ noted below under the section "Searching" and I'm sure you will find a solution.

You didn't mention whether you were using a keyword search or a custom search form.

The FAQ provides various search options to choose from.

Unoffical DBMan FAQ
http://redundantcartridge.com/dbman/
Quote Reply
Re: [LoisC] Entering more than one term in a field In reply to
Thank you Lois.
I am working with item 762 in the search pages.
Tony.
Quote Reply
Re: [tbalazs] Entering more than one term in a field In reply to
So my next question is...(and I can't see anything in the FAQ relating directly to this) can I have 3 search fields searching the same field, so that effective;y I am doing a Boolean AND in that field?
Tony.
Quote Reply
Re: [tbalazs] Entering more than one term in a field In reply to
Can you do a AND?
Yes by default the search is an AND.

Can you search the same field 3 times?
If you duplicate the field either in the database or create temporary "fields" you can. If you need a specific example let me know and I can dream one up.Laugh

There was a similar (but not exactly the same) situation a while back, and I think you could gleen the information you need from the post below. Perhaps go directly to the end of the thread where the solution was posted.

http://www.gossamer-threads.com/...orum.cgi?post=205584

Last edited by:

joematt: Sep 4, 2002, 9:37 AM
Quote Reply
Re: [joematt] Entering more than one term in a field In reply to
Ah yes this is terrific. Thank you joematt. By simply adding
$values[24] = $values[23];
$values[25] = $values[23];

after
# Normal searches.

the program's doing just what I want.
Tony. Smile