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

[spinhead]

> At 03:42 PM 1/10/2002, spinhead wrote:
> >=======================
> >   strQuery = "DECLARE @PonID int EXECUTE sp_pon_Add " & strPoID & ",
@RetVal
> >= @PonID OUTPUT"
> >   Set AddPON = objConn.Execute(strQuery)
> >=======================
> >
> >So now, how do I get the value of @PonID into a VBScript variable?
>
> Try this on the next line...
>
>          varPonID = AddPON(0)
>          AddPON.Close
>

Made sense to me, but  gets the 'item cannot be found in the collection'
error.

joel