[ic] Search Problem

Cameron B. Prince cplists at princeinternet.com
Tue Apr 14 19:12:10 UTC 2009


I¹m having a problem with a search and I wonder if anyone could provide some
insight. The object is to limit results based on a column (sresults) in the
products table.

Here is the search:

<form action="[area search]" method="post">
<input type="hidden" name="mv_search_file" value="products" />
<input type="hidden" name="mv_searchtype" value="db" />
<input type="hidden" name="mv_matchlimit" value="999" />
<input type="hidden" name="mv_sort_field" value="category,title" />
<input type="hidden" name="mv_coordinate" value="yes" />
<input type="hidden" name="mv_substring_match" value="yes" />

<input type="hidden" name="mv_search_field" value="sresults" />
<input type="hidden" name="mv_searchspec" value="1" />
<input type="hidden" name="mv_column_op" value="==" />
<input type="hidden" name="mv_numeric" value="1" />

<input type="hidden" name="mv_search_field" value="title, description,
comment" />
<input type="text" name="mv_searchspec" value="" />
<input type="hidden" name="mv_column_op" value="rm" />
<input type="hidden" name="mv_numeric" value="0" />

<input type="submit" value="Submit" />

The problem is this search returns items containing an empty value or NULL
in the sresults field.

This is essentially the same search listed here under ³Multiple table
(joined) coordinated search examples² except I¹m not using multiple tables.


Removing mv_substring_match makes no difference either. The only time it
works properly is if you remove the second set of search parameters (sf, se,
op, nu). It will then return every item that has sresults set to 1.

You can test this and obtain similar results on the standard v5.6.1 catalog
by dropping the form above into a test page and changing "sresults" to
"dl_location" in the first mv_search_field input. This field is empty in the
default standard catalog's products table.

If you search for "tool" in the test form, you'll see that 3 results are

Is something wrong with my form, or could this be a bug?

Any help would be greatly appreciated.


More information about the interchange-users mailing list