Gossamer Forum
Home : Products : Links 2.0 : Discussions :

Searching multiple fields with differrent and multiple keywords

Quote Reply
Searching multiple fields with differrent and multiple keywords
I've been playing around with links for a couple of weeks now and I have some questions on it's search capabilities.

Here is an example of where I have gotten to and where I want to go.

field 1 = location field 2 = movie field 3 = snacks

If I wanted to search for a location in Connecticut that is playing The
Tigger Movie and sells Chocalate Bars

My search would look like this
search.cgi?location=Connecticut&movie=The_Tigger_Movie&snacks=Chocolate_Bars

That far I've gotten and it works

Now what if I wanted to do the same search except for two locations at the
same time say Connecticut and Maine

I created my own search page and used several different multiple select
boxes (one for each field) but it would just use the & connetcor so it
would look like.
search.cgi?location=Connecticut&location=Maine&movie=The_Tigger_Movie&snacks
=Chocolate_Bars

search results "no matching records"

Can this be done with links?
Does the search.cgi have to be modified or is it just how the search criteria is submitted to links that I need to work with.

Thanks much everyone for any help you can give.
Quote Reply
Re: Searching multiple fields with differrent and multiple keywords In reply to
What you are looking for is a Boolean search option, which LINKS and DBMAN do not offer.

Like the following...in the search blank:

Connecticut and Maine and The Tigger Movie and Food

Then the query would like the following:

Code:
search.cgi?location=Connecticut+Maine&movie=The%20Tigger%20Movie&snacks=Chocolate%20Bars

LINKS cannot do this. Nor can DBMAN at this time.

BTW: Most if not all search queries put %20 for spaces NOT underscore characters.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. :)
----------------------









Quote Reply
Re: Searching multiple fields with differrent and multiple keywords In reply to
Thanks for the info Eliot,

Would you happen to know if this is something that could be done with Links SQL?
Quote Reply
Re: Searching multiple fields with differrent and multiple keywords In reply to
The search engines differ a lot between the flat file systems and SQL. Search the LINKS SQL Forum for ideas.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. :)
----------------------