<CFQUERY datasource="serviceimport2" name="mydata" USERNAME="#myusername#" PASSWORD="#mypassword#"> select field_3 as ro, field_102 as rodate, field_97 as advisornum, field_6 as customerid, field_2 as storeid from #session.myimportfile# WHERE field_102 > '#dateadd(d,-30,"#dateformat(now(),"dd/mm/yyyy")#")#' </CFQUERY>
Quote
Error Diagnostic Information
An error occurred while evaluating the expression:
#dateadd(ww,-4,"#dateformat(now(),"dd/mm/yyyy")#")#
Error near line 11, column 21.
Error resolving parameter d
ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either:
1. You have misspelled the parameter name, or
2. You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag.
The error occurred while processing an element with a general identifier of (#dateadd(ww,-4,"#dateformat(now(),"dd/mm/yyyy")#")#), occupying document position (11:20) to (11:70).
An error occurred while evaluating the expression:
#dateadd(ww,-4,"#dateformat(now(),"dd/mm/yyyy")#")#
Error near line 11, column 21.
Error resolving parameter d
ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either:
1. You have misspelled the parameter name, or
2. You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag.
The error occurred while processing an element with a general identifier of (#dateadd(ww,-4,"#dateformat(now(),"dd/mm/yyyy")#")#), occupying document position (11:20) to (11:70).