Conditional Expression in ColdFusion
Use the function iif(). There is no operator or expression syntax.
This was remarkably hard to find out. There seem to be a lot of people who don't know what one is. Also, the term gets used to refer to the condition that is evaluated for a case statement. The CF case statement is a <cfswitch> I believe. And it seems to be in an error message that is frequently encountered in an attempt to write a query on a query.
So for experts who know languages and what a conditional expression is, but might be coming to ColdFusion recently like me, this might hopefully get indexed and turn up in searches.
No reply required.
