Legend

Answered

QoQ and modulus?

Forum|Forum|8 years ago
October 18, 2017
19 replies
1620 views

Hello, all,

I have been trying to use a modulus in a QoQ, and it's not working.

SELECT cola, colb, colc 
FROM queryName 
WHERE cola % 2 = 0 
/* cola is an integer 1 - 10 */

.. and I get..

Encountered "cola 2 =. Incorrect conditional expression, Incorrect conditional expression, Lexical error at line 1, column 45. Encountered: " " (32), after : "%"

The error occurred on line 445.

(There are 16 lines of code, so I assume that the line 445 is in query.cfc.)

Can you use % or mod() in a QoQ???

V/r,

^ _ ^

This topic has been closed for replies.

Correct answer EddieLotter

I created a quick test and got the same error.

It appears the modulus operator is not supported in QoQ.

Cheers

Eddie

BKBK

Community Expert

WHERE cola MOD 2 = 0

EddieLotter

Inspiring

BKBK wrote
WHERE cola MOD 2 = 0

That gives the lovely message:

Encountered "MOD 2. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, Unrecognized comparison operator,

Note further that the message opens a double-quote but does not close it and ends with a comma.

Cheers

Eddie

BKBK

Community Expert

There's really no modulus operator in query-of-query? I am surprised - and a bit disappointed. @Wolfshade, let us know when you're done with the feature request. Then we can vote for it.

EddieLotterCorrect answer

Inspiring

I created a quick test and got the same error.

It appears the modulus operator is not supported in QoQ.

Cheers

Eddie

WolfShadeAuthor

Legend

Bummer. I'll go and submit a feature request, coz that could definitely come in handy.

V/r,

^ _ ^

EddieLotter

Inspiring

If you are populating the query from a database and then using QoQ to process the database query results, an interim solution to your scenario would be to add a column using the modulus operator in your database query. You can then use that additional column's value as a simple integer in your QoQ.

Cheers

Eddie

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.