Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Retrieving stored procedure parameters for modification Expand / Collapse
Author
Message
Posted Wednesday, October 17, 2007 5:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 19, 2007 7:10 AM
Points: 1, Visits: 5
An ADO question:
Can a single stored procedure parameter be retrieved from the parameters collection, have its value modified, and replaced in the parameters collection so that the stored procedure can be executed again? I am using ADO in ASP with VBScript.

Thanks,
Steve
Post #411968
Posted Thursday, October 18, 2007 2:24 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:35 AM
Points: 2,397, Visits: 3,417
I think OLE/AdoDB has a "refresh" method that will try to get the parameters with datatype and direction for you.



N 56°04'39.16"
E 12°55'05.25"
Post #412089
Posted Friday, October 19, 2007 6:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 9, 2011 8:34 AM
Points: 13, Visits: 85
Yes, Using a command object.
With objCommand
.Parameters.Item(1).Value = NewValue
.Parameters.Item(2).Value = NewValue
.Execute
End With
Post #412728
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse