Skip to main content
Inspiring
May 18, 2013
Answered

Variable REPORTQUERY is undefined.

  • May 18, 2013
  • 1 reply
  • 520 views

<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,

    This topic has been closed for replies.
    Correct answer iccsi

    it works if I use CFQUERY,

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

    Regards,

    Iccsi,

    1 reply

    iccsiAuthorCorrect answer
    Inspiring
    May 20, 2013

    it works if I use CFQUERY,

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

    Regards,

    Iccsi,