We are upgrading ASP application to ASP.Ne
Previously, we were able to populate an output paramenter for a Sql server 2000 stored procedure, execute the command, and the query the parameter object for its new value (it was being updated by the stored procedure)
I can confirm, through tracing that the return parameter is being updated by SQL, however, the updated value is NOT bubbling back up to the Parameter object. Yes, the stored procedure is declaring the parameter as "OUTPUT
My code for creating and populating the parameter is
prmLastUpdated = cmm.CreateParameter("LastUpdated",adDBDate, adParamInputOutput)
cmm.Parameters.Append(prmLastUpdated)
prmLastUpdated.Value = dtLastUpdated
and the code for looking back at it after the Execute() has been issued is
dtLastUpdated = cmm.Parameters.Item(idxTimestamp).Value
It appears the move to the ASP.Net engine (and JScript.Net from javascript) has stopped this happenning. Can anyone shed any light please
[MSFT] - 30 Apr 2004 04:56 GMT
Hello,
Is the code run from client side or server side? can you provide more code
to show us how you open the connection and create the command object?
Luke
Microsoft Online Support

Signature
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
[MSFT] - 04 May 2004 07:12 GMT
Hello,
Is there any updates? Has the problem been resolved?
Luke
Microsoft Online Support

Signature
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)