Get the return value from Stored Procedure
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?
