[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