>
> 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
Thats because the correct syntax for SQL would be:
WHERE Field1 = 'yes'
"IS" would be the equality check for Cold Fusion.
Brian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
