We have a brand new look! Take a tour with us and explore the latest updates on Adobe Support Community.
Copy link to clipboard
It has been a known fact that in older versions of ColdFusion you could not use the CASE WHEN THEN statements inside a query of queries like you can in a SQL query to a database.
Has this changed for CF2016?
What about the use of IF and ELSE-IF and ELSE statements in a query of queries?
We are using MS SQL Server.
I haven't used CF2016, so can't really speak as to whether or not CASE/WHEN statements work in QoQ, but I'm going to guess not.
The IF/WHEN should work. But even if not, you should be able to use CFSWITCH inline (I've never tried it.)
I recently discovered that modulus does not work in QoQ, and submitted a bug to Adobe for it. Three others have voted on it, and it is still "open".
There are a lot of things that are not supported in QoQ that should be.
^ _ ^