stevejbortman
SSC Rookie
Points: 27
More actions
October 17, 2007 at 5:06 pm
#118692
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
SwePeso
SSC-Dedicated
Points: 39757
October 18, 2007 at 2:24 am
#743030
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"
Jim S
SSC Veteran
Points: 239
October 19, 2007 at 6:28 am
#743554
Yes, Using a command object.
With objCommand
.Parameters.Item(1).Value = NewValue
.Parameters.Item(2).Value = NewValue
.Execute
End With
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply