[thelist] returning output from MSSQL to vbscript

[Matt Warden]

On 4/18/06, Canfield, Joel <JCanfield at pacadvantage.org> wrote:
> > When you use an OUTPUT parameter like that, I think you have
> > to get the value by reading the value of the parameter,
> > post-execution, rather than getting it from a recordset as
> > though you had done a SELECT.
>
> makes sense; pointers on how, or where to read how?
>
> thanks

cmd.parameters.append cmd.createparameter("@intIDOut", adInteger,
adParamOutput, oVal)
Response.Write "@intIDOut = " & cmd.parameters("@intIDOut").value

--
Matt Warden
Miami University
Oxford, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.