[thelist] capturing returned value from MS-SQL stored procedure

[Warden, Matt]

On Jan 10, spinhead had something to say about [thelist] capturing returned...


>So now, how do I get the value of @PonID into a VBScript variable? I tried
>this
>
>  strPonID = @PonID
>
>and
>
>strPonID = AddPON(@PonID)
>
>and get told that '@' is an invalid character. Tried
>
>strPonID = AddPON("@PonID") and got the error
>
>Item cannot be found in the collection corresponding to the requested name
>or ordinal.
>
>Help me help me. And, thanks.

yeah, that's one huge pain in the ass (imnsho) with ASP. you can't access
output params like that. you have to use the parameters collection.

http://www.google.com/search?q=asp+%22stored+procedure%22+%22output+parameter%22

hope this helps,

--
mattwarden
mattwarden.com