On 5/29/01, Denton penned:
>Hi All,
>
>I am a CF newbie and getting the hang of it but this is giving me trouble:
>
>I have a query like this on a search action page;
<snip>
> <cfif form.startyear is not "">
> and Year GTE #form.startyear#
> </cfif>
Make the last part:
and Year >= #form.startyear#
CFIF - SQL
IS or EQ - =
IS NOT or NEQ - <>
GT - >
LT - <
GTE - >=
LTE - <=
This gave me fits for months when I first started. LOL
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
