Coordinated search on numerical values

["B.J. Bezemer" <bas.bezemer@wxs.nl>]

******    message to minivend-users from "B.J. Bezemer" <bas.bezemer@wxs.nl>     ******

Hello,

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]

Tried it on all paintings with but that won't work either:
 [page scan
            co=yes
            sf=price
            se=30000000
            op=>
                        nu=1      ] above $30,000,000[/page]

The above could be done with range checking and works, but range checking
doesn't allow you to check on another column as well. And I really want to
solve this with a coordinated search. I tried the exact example from the
manual on the "simple" catalog and also gives no results:

[page scan
co=yes
sf=title
se=Sunflowers
nu=0
op=!~
sf=artist
se=Van Gogh
op=rm
nu=0
sf=inventory:qty
se=1
op=>=
nu=1      ] Any in stock except Sunflowers, Van Gogh [/page]


Eh.... Help.

With kind regards,
Bas Bezemer






-
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