[ic] Search across auxiliary products not work

interchange-users@icdevgroup.org interchange-users@icdevgroup.org
Sat Apr 26 21:06:01 2003


How should I do to search across products and auxiliary products tables?

It may be many discussion on this list but I could not find the answer.



<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">


Thanks in advance
Tom

Kidanet business
Murahashi