[ic] Search Returning 3 out of 6 results

[interchange-users@interchange.redhat.com (Mike Heins)]

Quoting Fred Pope (fred@satcomresources.com):
> >IC 4.8.3 - MYSQL - RH 7.1
> >
> >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.
> >
> 
> "Perhaps you could post the data in your tables as well as the code you are
> using for searches."
> 
> 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="*">

This is definitely wrong. You can't have a coordinated search for all
fields like this. You are essentially searching the entire record
for "french" and "1", and I bet each of the three that are returned
have a 1 in them and the three that aren't don't.

You probably need:

 	      <INPUT TYPE=hidden NAME=mv_search_field VALUE="inactive">
 	      <INPUT TYPE=hidden NAME=mv_search_field VALUE=":*">

-- 
Red Hat, Inc., (emailing wirelessly from my laptop, on Perl Whirl
in the Caribbean Ocean) Geek Cruises (www.GeekCruises.com)
phone +1.513.523.7621 fax 7501 <mheins@redhat.com>

I don't buy from direct telephone or email marketers.  This makes it
hard for me to find a phone company. ;>