Variable REPORTQUERY is undefined.

[iccsi]

<cfstoredproc datasource="MyDSN" procedure = "MySP">

     <cfprocparam value = "1" CFSQLTYPE = "cf_sql_numeric">

</cfstoredproc>

for my report query using a stored procedure need parameter.

I got Variable REPORTQUERY is undefined.

I notice that the default name for query report is ReportQuery, but CFSTOREDPROC  doex not have name property.

I am not sure how I can assign the variable using a stored procedure.

Your help and information is great appreciated,

Regards,

Iccsi,

[iccsi · Accepted solution]

it works if I use CFQUERY,

since CFQUERY can be named and can have execute stored procedure syntax,

Regards,

Iccsi,