I'm using a stored procedure from an ASP page using a ADODB connection, the sproc returns a value and also has an output parameter.
Both are being read in the page but they are both empty, I profiled the sproc call and tested it directly and the values are being returned correctly.
What could the problem be? quick note: in another server the same code works fine.
The code I'm using to get the values looks like...
2 results in 0.0014 seconds.
-
Output parameter read from stored procedure empty
-
How to capture MSSQL SP output / multiple select statement results?
Hi All,
I'm facing a problem I'm unable to find a solution for. I hope fellow members would be able to help me out.
System Info:
PHP v5
MSSQL 2008
Linux box
Ok lets say I have a stored procedure called proc_getData which has 2 select
statements....
...Code:Create Proc proc_getdata AS Select COUNT(*) From Usr_Accounts; select
