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)
|
|
|
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 |
|
|
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.
|
|
|
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 |
|
|
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.
|
|
|