[thelist] returning output from MSSQL to vbscript
Tab Alleman
talleman at Lumpsum.com
Tue Apr 18 14:39:09 CDT 2006
I read it in a WROX book. : )
probably if you google "ASP stored procedure parameters" you'll find something useful...sorry I don't remember exactly how to do it anymore.
In pseudo code it will be something like:
Create a command object with commandtype=adStoredProcedure and commandtext="YourSPName"
Create a parameter object with a name and type=OUTPUT
Add the parameter object to the command object's Parameters collection.
.Execute the command object
Get your output from YourParameterName.value
HTH
> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Canfield, Joel
> Sent: Tuesday, April 18, 2006 3:22 PM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] returning output from MSSQL to vbscript
>
>
> > 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
> --
>
> * * 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