Re: Coordinated search on numerical values

[mikeh@minivend.com]

******    message to minivend-users from mikeh@minivend.com     ******

Quoting B.J. Bezemer (bas.bezemer@wxs.nl):
> 
> I'm trying to get the coordinated and joined searching to work with a
> numerical comparison in it. String comparisons (op=ge, op=le, op=eq) work
> ok, but but the numerical part gives me trouble. Has anybody got this
> working allready. I'm using MV 3.11 on Redhat 5.0
> 
> Here is what I've done to come to the conclusion that I have a problem.
> Let's say that I want search for all Van Gogh's paintings priced above
> $30,000,000. The following won't give the desired results
> 
>  [page scan
>             co=yes
>             sf=artist
>             se=Vincent Van Gogh
>             op=eq
>                         nu=0
>             sf=price
>             se=30000000
>             op=>
>                         nu=1      ] Van Gogh above $30,000,000[/page]
> 
>

You are right, it doesn't work with "eq". Luckily, you shouldn't use
eq 8-). Use rm; that will give you a screening function that will speed
search dramatically.

The rest of the searches should work; here are some links:

http://www.minivend.com/cgi-bin/simple/scan/co=yes/sf=title/se=Sunflowers/nu=0/op=%21%7e/sf=artist/se=Van%20Gogh/op=rm/nu=0/sf=inventory%3aqty/se=1/op=%3e%3d/nu=1

http://www.minivend.com/cgi-bin/simple/scan/co=yes/sf=artist/se=Van%20Gogh/op=rm/nu=0/sf=price/se=30000000/%3e%3d/nu=1

http://www.minivend.com/cgi-bin/simple/scan/co=yes/sf=title/se=Sunflowers/nu=0/op=%21%7e/sf=artist/se=Van%20Gogh/op=rm/nu=0/sf=inventory%3aqty/se=1/op=%3e%3d/nu=1

(The last one works now, but if inventory goes below 1 it may not. 8-)

-- 
Mike Heins                          http://www.minivend.com/  ___ 
                                    Internet Robotics        |_ _|____
I don't buy from direct             131 Willow Lane, Floor 2  | ||  _ \
telephone or email marketers.       Oxford, OH  45056         | || |_) |
This makes it hard for              <mikeh@minivend.com>     |___|  _ <
me to find a phone company. ;>      513.523.7621 FAX 7501        |_| \_\
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list