[thelist] returning output from MSSQL to vbscript

[Tab Alleman]

Yeah, something like that... except don't forget to cmd.execute() before getting the output parameter's value.

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Matt Warden
> Sent: Tuesday, April 18, 2006 3:40 PM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] returning output from MSSQL to vbscript
> 
> 
> 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.
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
>