> Thank you for your response. I would normally agree with you however in
> my specific case I feel I need to use verity. I neglected to mention all
> the other search criteria that is involved in order to simplify the
> question and not cause confusion. Doing a simple price range search in
> SQL
> True - but I had assumed this was only part of his query. If
> this truly WAS the only part, than a pure SQL search makes a
> lot more sense. My bad. If he is using this with other items,
> then I think it would make sense in Verity.
Assuming there aren't too many records, you could use QoQ t
True - but I had assumed this was only part of his query. If this
truly WAS the only part, than a pure SQL search makes a lot more
sense. My bad. If he is using this with other items, then I think it
would make sense in Verity.
On 6/20/07, Dave Watts <[EMAIL PROTECTED]> wrote:
> > Well I have a pr
Hi Dave,
Thank you for your response. I would normally agree with you however in
my specific case I feel I need to use verity. I neglected to mention all
the other search criteria that is involved in order to simplify the
question and not cause confusion. Doing a simple price range search in
ic searching.
>
> -- Mike Eger
> www.avilar.com
>
> -Original Message-
> From: Matthew Lesko [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 20, 2007 10:28 AM
> To: CF-Talk
> Subject: Query Based Verity Issue
>
> Well I have a problem with a verity searc
, 2007 10:28 AM
To: CF-Talk
Subject: Query Based Verity Issue
Well I have a problem with a verity search I am doing. The collection is
based off a query of product data. My collection has cf_custom2 data in
it which represents the products price. When I search the collection
with:
criteria
Thank you Raymond. I figured it was working with the decimal as a string
but I was not sure and I did not know it was limited to just strings. I
like your idea of categorizing my price ranges so I can set my criteria
against a string.
Raymond Camden wrote:
> Verity does string based searching,
> Well I have a problem with a verity search I am doing. The
> collection is based off a query of product data. My
> collection has cf_custom2 data in it which represents the
> products price. When I search the collection with:
>
> criteria="CF_CUSTOM2 <= 19.99"
>
> I will get results with CF_
Subject: Query Based Verity Issue
Well I have a problem with a verity search I am doing. The collection is
based off a query of product data. My collection has cf_custom2 data in it
which represents the products price. When I search the collection with:
criteria="CF_CUSTOM2 <= 19.99"
I wil
Verity does string based searching, not numerical base searching. What
you may consider is an alternative. All products that are < 20 bucks
are considered cheap. When inserting the data, use a criteria, or a
category, of cheap.
On 6/20/07, Matthew Lesko <[EMAIL PROTECTED]> wrote:
> Well I have a
Well I have a problem with a verity search I am doing. The collection is based
off a query of product data. My collection has cf_custom2 data in it which
represents the products price. When I search the collection with:
criteria="CF_CUSTOM2 <= 19.99"
I will get results with CF_Custom2 with valu
11 matches
Mail list logo