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

Question

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.

WolfShade · Answer

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,

^ _ ^

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded