[thelist] returning output from MSSQL to vbscript

Matt Warden mwarden at gmail.com
Tue Apr 18 14:39:55 CDT 2006

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

This email proudly and graciously contributes to entropy.

More information about the thelist mailing list