[ic] Search Returning 3 out of 6 results

[Jon Jensen]

On Fri, 18 Jan 2002, Fred Pope wrote:

> >I am having some problems with the search feature. I have six items that
> >have the word "french" in the title of the product. When I do a search, it
> >is only pulling up three of the six items in the result set.
[snip]
> Here is the search code:
>
> <INPUT TYPE=hidden NAME=mv_coordinate VALUE=1>
> 	      <INPUT TYPE=hidden NAME=mv_searchtype VALUE=db>
> 	      <INPUT TYPE=hidden NAME=mv_matchlimit VALUE=[control matches 1]>
> 	      <INPUT TYPE=hidden NAME=mv_sort_field VALUE=category>
> 	      <INPUT TYPE=hidden NAME=mv_search_field VALUE="*">
> 	      <input type=hidden name=mv_substring_match value=1>
> 	      <INPUT TYPE=hidden NAME=mv_column_op VALUE=ne>
> 	      <INPUT TYPE=hidden NAME=mv_column_op VALUE=rm>
> 	      <INPUT TYPE=hidden NAME=mv_searchspec VALUE=1>
> 	      <INPUT MAXLENGTH=30 NAME=mv_searchspec type=text size=10>

There may or may not be a problem with non-ASCII characters, but in the
meantime I think you can fix your search by turning of mv_coordinate
and simplifying a bit:

<INPUT TYPE=hidden NAME=mv_searchtype VALUE=db>
<INPUT TYPE=hidden NAME=mv_matchlimit VALUE=[control matches 1]>
<INPUT TYPE=hidden NAME=mv_sort_field VALUE=category>
<input type=hidden name=mv_substring_match value=1>
<INPUT MAXLENGTH=30 NAME=mv_searchspec type=text size=10>

Jon