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" <suppressed> 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 > suppressed > http://www.icdevgroup.org/mailman/listinfo/interchange-users _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.