[ic] Calling all search gurus

[Ton Verhagen]

Quoting Ed LaFrance (edl@newmediaems.com):
>mv_search_field="field1,field2,field3,field4"
>mv_searchspec="foo"
>
>mv_search_field="field5"
>mv_searchspec="1"
>
>I need to find all products which have /foo/ in any of the corresponding 
>fields, AND do not have '1' in the other field.  I thought this would be a 
>simple coordinated search:

Ed I got this code in an old construct demo running IC4.6.4 and it runs okay.

<FORM 
ACTION="http://www.yourdomain.com/cgi-bin/construct/search.html?mv_pc=556">
<INPUT TYPE=hidden NAME=mv_coordinate VALUE=1>
<INPUT TYPE=hidden NAME=mv_searchtype VALUE=db>
<INPUT TYPE=hidden NAME=mv_search_file VALUE=products>
<INPUT TYPE=hidden NAME=mv_substring_match VALUE=1>
<INPUT TYPE=hidden NAME=mv_substring_match VALUE=1>
<INPUT TYPE=hidden NAME=mv_matchlimit VALUE=10>
<INPUT TYPE=hidden NAME=mv_sort_field VALUE=category>
<INPUT TYPE=hidden NAME=mv_search_field VALUE=inactive>
<INPUT TYPE=hidden NAME=mv_search_field VALUE=":*">
<INPUT TYPE=hidden NAME=mv_column_op VALUE=ne>
<INPUT TYPE=hidden NAME=mv_column_op VALUE=rm>
<INPUT TYPE=hidden NAME=mv_searchspec VALUE=1>
<INPUT MAXLENGTH=30 NAME=mv_searchspec type=text size=10>

I'm sure you could change this around to fit your needs.

Good luck.

Ton