[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
http://mattwarden.com
This email proudly and graciously contributes to entropy.
More information about the thelist
mailing list