This content has been marked as final. Show 5 replies
Your resultset will not be exposed as output parameters. Omit the cfprocparam tags in your code.
Blue Chrome wrote:1 person found this helpful
><cfprocparam type="out" value="#Name_Long#" cfsqltype="cf_sql_varchar">
><cfprocparam type="out" value="#Entity_ID#" cfsqltype="cf_sql_integer">
Value="#Name_Long#" is trying to make use of a ColdFusion variable named
'Name_long' and pass it into an out parameter.
I don't think you want to be doing that, but I'm not sure I know what
you do need to be doing.
My first guess is that you don't want any <cfprocparam ...> tags because
I do not see and parameters being passed out of your proceedure.
My second guess would be that if you do want <cfproceparam...> tags then
you want to be using the variable="Name_Long" to define the ColdFusion
variable to receive the value of the parameter rather then the
value="#Name_Long#" which would be used to send a value into the stored
Thanks for helping a newbie out guys, eliminating the cfprocparam tags fixed the problem. I'll be back to this forum soon I'm sure.
You might find the attached script helpful. I use this in SQL Management Studio to generate the ColdFusion tags used to call stored procedures. Note that you will need to add cfprocresult tags manually
Bob - Thanks, but that's a little advanced for me right now. I'll hold onto the script for later.