Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Languages / JScript / May 2004

Tip: Looking for answers? Try searching our database.

Receiving COM return parameter value in ASP.Net not working

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
markeboy - 29 Apr 2004 23:26 GMT
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.)


Rate this thread:







Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.