[ic] Latest IC not honoring mv_all_chars (ac=1)

Mike Heins interchange-users@icdevgroup.org
Mon Oct 28 15:42:01 2002


Quoting Luc Knaven (l.h.m.knaven@inter.nl.net):
> IC version: 4.9.3-200210280658
> 
> It seems that the latest Interchange version doesn't like 'special'
> characters in a search.
> 
> Let me explain:
> The comb_category field in the products table contains values like:
> 
> centrifuges:algemene centrifuges, gekoeld:4 x 0,5 - 100 ml. (max. 400ml.
> totaal)
> centrifuges:algemene centrifuges, gekoeld:> 4000 ml. Totaal
> dispergeerapparatuur:volume 0,5 - 2000 ml.
> schudders/ mengers:horizontaal
> 
> etc...
> 
> 
> The following search does NOT return anything:
> 
> [loop search=|
>    fi=products
>    st=db
>    ac=1
>    bs=1
>    tf=comb_category,description
>    sf=comb_category
>    se=centrifuges:algemene centrifuges gekoeld:4 x 0 - 100 ml. (max. 400ml.
> totaal)

Add these options:

	su=1
	em=1

The problem is that the default behavior in a non-coordinated search is to
do a "word" search, where each thing is a word that is ANDed (or ORed) together
to find words.

To turn that off and have it be treated as one searchspec, you need em=1.
To prevent word qualification problems, you need su=1.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

Any man who is under 30, and is not liberal, has not heart; and any man
who is over 30, and is not a conservative, has not brains.
 -- Winston Churchill