[prev in list] [next in list] [prev in thread] [next in thread] 

List:       interchange-users
Subject:    [ic] coordinate search
From:       Andrew <andrew () gnghardware ! com>
Date:       2003-07-31 13:37:57
[Download RAW message or body]

using IC 4.8.7
I believe I am using mv_orsearch incorrectly.

I have a number of items containing both "black" and "camera" in their 
description. There are other items with just "black" or just "camera".
Searching for "black" or "camera" will bring up the corresponding items. 
Searching for "black camera" returns only items that have "black camera".
I believe searching for "black camera" with mv_orsearch=1 should return 
every item containing either "black" or "camera" or both.

I have been working on this for a while, looking through the archives 
and piecing together the following code:

[set show_search]
mv_searchtype=sql
mv_search_file=products
mv_coordinate=1
mv_matchlimit=5
mv_search_relate=0 and 1
[/set]
[set normal_search]
[perl]
$out = 'mv_search_field=' . join("\0", 'show_item', 
':company:keywords:code:description') . "\n";
$out .= 'mv_searchspec=' . join("\0", 1, $CGI->{searchstring}) . "\n";
$out .= 'mv_orsearch=' . join("\0", 0, 1) . "\n";
$out .= 'mv_search_group=' . join("\0", 0, 1) . "\n";
$out .= 'mv_substring_match=' . join("\0", 0, 1) . "\n";
$out .= 'mv_column_op=' . join("\0", 'eq', 'rm') . "\n";
$out;
[/perl]
[/set]
<form action="[area search]" method=post name="searchform2">
<input type=hidden name=mv_profile value=show_search>
<input type=hidden name=mv_check value=normal_search>
<input type=text name=searchstring size=13>
<a href="javascript:document.searchform2.submit();" class="nav_a">Go</a>
<input type=hidden name=searchtype value=search>
</form>

Thanks,
Andrew LeBaron

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users
[prev in list] [next in list] [prev in thread] [next in thread]