Discussion:
Is there a "between" operator for CFIF?
(too old to reply)
EvolvedDSM
2007-01-30 20:25:05 UTC
Permalink
Rather than including both a GTE and LTE in a CFIF when I want to find
something between two values, is there an operator that I can include to simply
things.
something like
<CFIF #column1# BETWEEN(value1, value2)>

Currently I have to do
<CFIF (#column1# GTE value1) AND (#column1# LTE value2))>

It just seems very redundant to include a GTE and LTE in the same statement
when my ideal example above would cover this in one operator.

So, is there anything out there for what I'm looking for?
Dan Bracuk
2007-01-30 20:47:31 UTC
Permalink
Cold Fusion has nothing like that. cflib.org is a repository of udf's. Maybe
there is something there.

Of course, looking at the example you gave, and nothing else, maybe you could
use the sql keyword "between" in your query so you don't have to worry about it
in Cold Fusion.

Loading...