CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Stored Procedure return value help

Print topic Send  topic

Author Message
PlanetTech

Posts: 13
Posted: 10/06/2009, 4:03 PM

Am hoping someone may be able to help me with retrieving the return value from an SQL Stored Procedure in ASP.

Store Procedure returns int value = @ConfigID

From the Stored Procedure parameter window
Name: @ConfigID Parameter: ConfigID
Data Type: Int URL
Direction: Return Value

Using the AfterInsert/AfterExecuteInsert how do I reference this value?
i.e. Reponse.Write (SP Return Value)
View profile  Send private message
Edd


Posts: 547
Posted: 10/08/2009, 6:04 PM

In the Stored procedure for the insert use the RETURN parameter and return it to a global or session variable. Then test it in the AfterInsert event.

Edd
_________________
Accepting and instigating change are life's challenges.

http://www.syntech.com.au
View profile  Send private message
PlanetTech

Posts: 13
Posted: 10/12/2009, 6:32 PM

Thanks Edd but could not get this to work?

I logged a call requesting help for this. The reply basically stated that the built-in code could not return values from stored procedures although this IDE implied it could. Was told I would have to write my own code.
View profile  Send private message
Edd


Posts: 547
Posted: 10/12/2009, 10:21 PM

Thanks for the PM on this - did support indicate that was going to be fixed?

I spent an hour playing with the IDE and see what you mean the base classes don't support returned values.

Cheers - Edd
_________________
Accepting and instigating change are life's challenges.

http://www.syntech.com.au
View profile  Send private message
PlanetTech

Posts: 13
Posted: 10/12/2009, 10:35 PM

Good to hear itís just not me with my limited knowledge.

I posted some code to support to comment and see what they have to say. There was no indication from the last response that this would be resolved. Possibly the inclusion in the IDE is for another language which does supported it however if this is the case it would be nice to have the documentation update to say so.

Will keep you posted.
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.