Quoting Marco Mescoli (suppressed): > 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 <suppressed> Experience is what allows you to recognize a mistake the second time you make it. -- unknown _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.