Re: QoQ and MOD function

[safo kaska]

so what can I do?? 

~|
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-talk/message.cfm/messageid:328168
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

QoQ and MOD function

[safo kaska]

newbie question

 i am using the following QoQ 

cfquery name=qaccbytyp dbtype=queryselect * from data where 
saab='#sanad.saab#' andsaan='#sanad.saan#' and saas='#sanad.saas#' and 
(sadrf='#manyref.sadrf#' or C=#lastD# or MOD(C,#ABS(firstD)#) =0 )/cfquery 

and i get this error 

Error Executing Database Query.  Query Of Queries syntax error.Encountered MOD 
( C ,. Incorrect conditional expression, Expected one of 
[like|null|between|in|comparison] condition,  

any ideas.
thanks . 

~|
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-talk/message.cfm/messageid:328117
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4