QoQ and MOD

View: New views
3 Messages — Rating Filter:   Alert me  

QoQ and MOD

by safo kaska :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


I was informed that MOD is not supported in QoQ, so what is the alternative?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4897
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.15

RE: QoQ and MOD

by Paul Kukiel-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


2 normal querys?

-----Original Message-----
From: safo kaskas [mailto:safokaskas@...]
Sent: Tuesday, November 10, 2009 3:21 AM
To: cf-newbie
Subject: QoQ and MOD


I was informed that MOD is not supported in QoQ, so what is the alternative?




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4898
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.15

Re: QoQ and MOD

by Maureen-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


Set a variable using the mod function, then use the variable in the query.

On Tue, Nov 10, 2009 at 12:21 AM, safo kaskas <safokaskas@...> wrote:
>
> I was informed that MOD is not supported in QoQ, so what is the alternative?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4899
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.15