so what can i do?????
> newbie question > > i am using the following QoQ > > <cfquery name="qaccbytyp" dbtype="query">select * 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:328166 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
