Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Need Query help

Quote Reply
Need Query help
I have a ENUM field (No, Yes) called CIH. My database has all the members of an organization in it... need to limit the searches so that only those members that are CIH will come up in a search (the search form at the top of every page). search.cgi?CIH=Yes did not work.

How can I get the search to find whatever search term the user puts in the form and return results where CIH=Yes only.

Tgardner

Quote Reply
Re: Need Query help In reply to
You need to do the following:

1) Add a hidden field in your search form codes:

Code:

<input type="hidden" name="CIH" value="Yes">


2) If you are linking to results, you need to use the following link codes within your template files:

Code:

<a href="<%db_cgi_url%>/search.cgi?query=&CIH=Yes">Search</a>


Note the bolded red codes....

Regards,

Eliot Lee
Quote Reply
Re: Need Query help In reply to
Eliot,

Thank you for your help and taking the time to give me examples.

Tommy