If you can change the data type of the Field1 you would be better to make it
a bit field and then use 1 for yes and 0 for no, then your CF logic and your
SQL will probably make more sense. Right now your trying to do String
Comparisons when what you really want to be doing by what you have put down
below is Boolean comparisons. Hope that makes sense, please let me know if
you need me to explain more.
-Bill Killillay
-----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
