CODEWITHSUNDEEP
stored-proceduresasp-classicsql-server-2000
RetroCoder
RetroCoder

Reputation: 2685

How do I get output parameters using asp from a exec sproc_name

In asp I'm trying to open a query that contains the exec to a sproc. It works fine with some input params and no output params. But I was trying to create some output params. How do I get the output params from my result set or should I try it a different way?

Upvotes: 1

Views: 3857

Answers (1)

Milimetric
Milimetric

Reputation: 13549

Check out this article on doing exactly what you want. The first example is reading from a record set and the second example is using output parameters. It shows how to create them and how to set and read their values with ADO:

http://msdn.microsoft.com/en-us/library/aa224819(v=sql.80).aspx

Upvotes: 2

Related Questions