[ic] [ic]coordinated search

Mathew Jones matjones@booksellersolutions.com
Mon, 11 Dec 2000 14:47:05 -0800


I am attempting to conduct a coordinated search where any CATEGORY
selected from the drop down category list, will be searched for in 5
different  columns in the database. In the example below I have it set to
search category1, but it should also search category2,3,4 & 5.

<input type=hidden name="mv_coordinate" value="yes">
<INPUT TYPE=hidden NAME=mv_search_map VALUE="
        mv_searchspec=search1
        mv_searchspec=search2
        mv_searchspec=search3
        mv_searchspec=search4
        mv_searchspec=search5
        mv_searchspec=search6
        mv_searchspec=search7 ">

 <INPUT TYPE=hidden NAME="mv_search_field" VALUE="author">
 <INPUT TYPE=hidden NAME="mv_search_field" VALUE="title">
 <INPUT TYPE=hidden NAME="mv_search_field" VALUE="price">
 <INPUT TYPE=hidden NAME="mv_search_field" VALUE="publisher">
 <INPUT TYPE=hidden NAME="mv_search_field" VALUE="notes">
 <INPUT TYPE=hidden NAME="mv_search_field" VALUE="annotation">
 <INPUT TYPE=hidden NAME="mv_search_field" VALUE="category1">

 <INPUT TYPE=text NAME="search1" value="" SIZE=15>
 <INPUT TYPE=text NAME="search2" value=""  SIZE=15>
 <INPUT TYPE=text NAME="search3" value=""  SIZE=15>
 <INPUT TYPE=text NAME="search4" value=""  SIZE=15>
 <INPUT TYPE=text NAME="search5" value=""  SIZE=15>
 <INPUT TYPE=text NAME="search6" value=""  SIZE=15>
 <SELECT NAME="search7">
    <OPTION VALUE=""> -- any --
    <OPTION value="fiction">FICTION
    <OPTION value="childrens">CHILDRENS
 </SELECT>

Thanks

Mat