[thelist] returning output from MSSQL to vbscript
Tab Alleman
talleman at Lumpsum.com
Tue Apr 18 15:04:45 CDT 2006
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 !
>
More information about the thelist
mailing list