[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Coordinated searching problem
****** message to minivend-users from mikeh@minivend.com ******
Quoting Christopher Thompson (Thompson-Jordan@mindspring.com):
> ****** message to minivend-users from "Thompson-Jordan" <Thompson-Jordan@mindspring.com> ******
>
> I am having a problem with a coordinated search and can't see what I've
> got wrong. I think I need to flip my comparisons or use AND or OR search,
> but I've tried a number of variations with no luck.
>
> I want a search that returns matches for a value if it is between the
> values in fields sizemin and sizemax. It's the reverse of mv_range_look.
> What I have works, sort of, but only returns records where either sizemin
> or sizemax are equal my value. Given the data below, my search only
> returns records 1 and 3, but not 2. Any ideas?
>
> code sizemin sizemax
> 1 50 100
> 2 50 150
> 3 100 150
> 4 150 200
>
> Here's the code:
>
> __NAME__ chksz
>
> mv_coordinate=yes
> mv_search_field=sizemin
> mv_search_field=sizemax
> mv_column_op=>=
> mv_column_op=<=
mv_numeric=yes
mv_numeric=yes
>
> __END__
>
> <a href="[area href=scan arg="mp=chksz/se=100]">Size 100</a>
>
> Thanks.
>
> Christopher Thompson
>
> -
> 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
>
--
Mike Heins http://www.minivend.com/ ___
Internet Robotics |_ _|____
131 Willow Lane, Floor 2 | || _ \
It's a little-known fact Oxford, OH 45056 | || |_) |
that the Y1K problem caused <mikeh@minivend.com> |___| _ <
the Dark Ages. -- unknown 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
