VS: [ic] Search across auxiliary products not work

[$BB<66>\;0(B:$BLZED%M%C%H%S%8%M%9(B]

Thank you Kent,

But I am sorry I can't your suggestion. My question was not clear.
What I would like to do is:
- search with one word across prodtct(products) and auxiliary 
products(products_jp)  table
- FORM style search
- GDBM database

Adding the following line is not work well.
<INPUT TYPE=hidden NAME=mv_search_field VALUE="products_jp:Description">

<FORM ACTION="[area search]">
<INPUT TYPE=hidden NAME=mv_coordinate VALUE=1>
<INPUT TYPE=hidden NAME=mv_searchtype VALUE=db>
<INPUT TYPE=hidden NAME=mv_matchlimit VALUE=20>
<INPUT TYPE=hidden NAME=mv_sort_field VALUE=category>
<INPUT TYPE=hidden NAME=mv_sort_field VALUE=brand>
<INPUT TYPE=hidden NAME=mv_search_field VALUE="sku">
<INPUT TYPE=hidden NAME=mv_search_field VALUE="title">
<INPUT TYPE=hidden NAME=mv_search_field VALUE="products_jp:Description">
<INPUT TYPE=hidden NAME=mv_substring_match VALUE=yes>
<INPUT TYPE=hidden NAME=mv_orsearch VALUE=yes>
<INPUT MAXLENGTH=30 NAME=mv_searchspec type=text size=10>
<INPUT TYPE=image alt="Search Go" border="0" src="navigation/go.gif" 
width="23" height="17">

"Kent-Rune_K.Sætrum" <kent@datamarked.no> wrote:
> > How should I do to search across products and auxiliary
> > products tables?
> 
> Sorry for repeating myself, I forgot to include three lines. Not its 
all
> included.
> 
> This is my set-up for the search module I use. Just change of course 
the
> parameter names that fit for your records, and this should do the work.
> You can also add more lines to the lines that containes mv_search_
field.
> Just copy/paste, and change/add the VALUE.
> 
> ---cut---
> 
> <FORM ACTION="[process-target]" METHOD="POST" name="searchform">
>     <INPUT TYPE="hidden" NAME="mv_searchtype" VALUE="glimpse">
>     <INPUT TYPE="hidden" NAME="mv_substring_match" VALUE="yes">
>     <INPUT TYPE="hidden" NAME="mv_search_file" VALUE="products.txt">
> 
>    <INPUT TYPE="hidden" NAME="mv_search_field" VALUE="sku" CHECKED>
>    <INPUT TYPE="hidden" NAME="mv_search_field" VALUE="kortbeskrivelse"
> CHECKED>
>    <INPUT TYPE="hidden" NAME="mv_search_field" VALUE="
langbeskrivelse1"
> CHECKED>
> 
>    <INPUT TYPE=image SRC="sokeknapp.gif" ALT="Click to start 
searching">
>    <INPUT TYPE="hidden" NAME="mv_doit" VALUE="search">
>    <INPUT TYPE="hidden" NAME="mv_search_page" VALUE="result_search">
> 
>    <INPUT MAXLENGTH="30" NAME="mv_searchspec" SIZE="22" VALUE="Search
> word" onClick='if (document.searchform.mv_searchspec.value == "Search
> word") document.searchform.mv_searchspec.value=""' style="font-size:
> 7pt; font-family: Verdana; color: #000000; background: #EEEEEE;">
> </FORM>
> 
> ---cut---
> 
> Hope this works out for you. Its also included a nice useful function
> you will see when you test :)
> 
> 
> Regards,
> Kent
> Datamarked AS
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users