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
