[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