[ic] [search-region] yet ...

Mike Heins mike at perusion.com
Thu Dec 27 14:53:18 EST 2007


Quoting Marco Mescoli (m.mescoli at omnib.it):
> I must put my hand on my old dirty code but i cannot find the way to 
> modify it ...
> 
> With minivend query i would obtain from products table all the items 
> that have at least a field containing "song" and have the field 
> category="cdrom"
> Tring with mv_search_group and mv_orsearch
> 
> [search-region
>   more=1
>   search="
>     st=db
>     ml=10
>     co=yes
>     tf=category
>     to=f
> 
>     sf=*
>     se=song
>     su=1
>     op=rm
>     sg=0
>     os=1
> 
>     sf=category
>     se=cdrom
>     su=0
>     op=em
>     sg=1
>     os=0
> "]
> 
> But this query seems to get only the records that have "test" inside sku 
> field.
> 

I think you want :* for the field.

But you are better off by far putting the second predicate,
the second category=cdrom, first.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

Experience is what allows you to recognize a mistake the second
time you make it. -- unknown


More information about the interchange-users mailing list