ColdFusion Report

[HoustonTX]

HI! ya'all, I am working on ColdFusion Report (Trial Version) in which I am
passing three parameters which are 'bDate' (begaining date), eDate (ending
date), and numberId. In query builder if I try this ?StoredProcedure_Report
'01/01/2004','01/01/2005',#param.Id#" it works fine but when I try
"StoredProcedure_Report #'param.eDate'#,#'param.eDate'#,#param.Id#" then
after passing the above date it gives me following error (Error Executing
Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near
'/'.)

Any ideas or suggestions will be appreciated.

[TA-Selene]

You need the single quotes outside of the # signs when you call the param.

It is much easier to use the CFSTOREDPROC tag as opposed to CFQUERY. It eliminates these kinds of issues.