1 Reply Latest reply: Oct 26, 2011 9:33 AM by -==cfSearching==- RSS

    Get the return value from Stored Procedure

    Phinehas1234 Community Member

      Hi,

       

      I have a stored procedure (e.g. sp_get_num) and it returns a integer number using the following statement:

      RETURN 0; -- for error flag

       

      However, when I use the following coldfusion statement to get the return value, I encounter some problems.

      <cfstoredproc procedure="sp_get_num" datasource="#application.ds#" returnCode="yes">

        <cfprocresult name="searchResults">

        </cfstoredproc>

       

      Now, I can only get the result of #searchResults.RecordCount# correctly. But, I still do not have idea on getting the return value. How can I get the return value?