I would use type 'bit' for the field instead of varchar. Where 1 is yes and
0 is no, then in your if
check if it is EQ 1 or EQ 0.
Mike
Michael T. Tangorre
--------------------------------------------
Web Applications Developer
Office Phone: 703-558-4746
Cellular Phone: 607-426-9277
AIM: CrazyFlash4
Personal Email: [EMAIL PROTECTED]
Work Email: [EMAIL PROTECTED]
School Email: [EMAIL PROTECTED]
--------------------------------------------
This Email contains MillenniuM Information
Systems, LLC Privileged Information which
is Customer or Business Sensitive.
--------------------------------------------
-----Original Message-----
From: Ken Monroe [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 10:07 AM
To: CF-Talk
Subject: CFIF Confusion
Hello!
I'm working with SQL Server 2000 and I have a query I'm confused about.
There's a field (FIELD1) that's defined as a VARCHAR. The field contains
either "Yes" or "No". I SELECT all records and then want to display
somthing different if FIELD1 is a "Yes" or "No".
The following structure works:
<cfif FIELD1 IS NOT "No">
Bunch of code
</cfif>
This structure does not work:
<cfif FIELD1 IS "Yes">
Bunch of code
</cfif>
I've also notice that in SQL, if I do a:
SELECT *
FROM TableName
WHERE (FIELD1 LIKE 'yes')
it works, but
SELECT *
FROM TableName
WHERE (Field1 IS 'yes')
does not work...
???
Thx
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
