Does CF2016 support SQL CASE statements in query of queries? IF ELSE?

Report · Mar 21, 2018

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.

Report · Mar 21, 2018

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.

V/r,

^ _ ^