My <cfdump var="#q_RptResult#"> show error

[alecken]

I'm calling a stor. proc. (in Sybase). If I don't cfdump the resultset, my application run without showing me any problem but when I put cfdump I got the error message saying: CF does not know what q_RptResult is

My code below:

<cfstoredproc procedure="myreport" datasource="#DSN#">

   <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@compcode" value="#compcode#">

   <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@InventYear" value="#InventYear#">

  <cfprocresult name="q_RptResult">

</cfstoredproc>

<cfdump var="#q_RptResult#"> <--- this causing error. Eliminate cfdump eliminate the error message

[BKBK]

Could we see the error message? In any case, don't you require a cfprocparam of type 'out'?

[jbreslow]

Try moving the CFPROCRESULT tag above the CFPROCPARAM tags. I am not sure if that will solve the issue but everywhere I use these tags the CFPROCRESULT comes first. Give it a shot.

<cfstoredproc procedure="myreport" datasource="#DSN#">

  <cfprocresult name="q_RptResult">

   <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@compcode" value="#compcode#">

   <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@InventYear" value="#InventYear#">

</cfstoredproc>

[Dileep_NR]

Hi,

          Please make sure your SP is return an 'OUT'