dotnet jscript: 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

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

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

Hello,

Is there any updates? Has the problem been resolved?

Luke
Microsoft Online Support

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