I'm not certain why the SQL statements you noted below would work the way
they do, but it's possible that the fields are padded with extra spaces
around the "yes" which is causing a problem.
Converting the field type from varchar to integer will solve the problem.
---mark
=========================================
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
=========================================
-----Original Message-----
From: Ken Monroe [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 7: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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
