Highlighted

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

Community Beginner ,
Mar 21, 2018

Copy link to clipboard

Copied

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.

Views

141

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

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

Community Beginner ,
Mar 21, 2018

Copy link to clipboard

Copied

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.

Views

142

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Mar 21, 2018 0
LEGEND ,
Mar 21, 2018

Copy link to clipboard

Copied

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,

^ _ ^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 21, 2018 1