returning 2 parameter

  • Thread starter Thread starter Stanley
  • Start date Start date
S

Stanley

I want ado code to execute a stored procedure and return
more than one output parmeter or return value. Any ideas.
Thanks,
Stan
 
Hi Stanley,

Add two or more output parameters to command object, set its Direction to
ParameterDirection.Output.
 
See my article on handling parameters:
http://www.betav.com/msdn_magazine.htm

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

Miha Markic said:
Hi Stanley,

Add two or more output parameters to command object, set its Direction to
ParameterDirection.Output.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Stanley said:
I want ado code to execute a stored procedure and return
more than one output parmeter or return value. Any ideas.
Thanks,
Stan
Click to expand...
Click to expand...
 
You can either link them together in a single select in the sproc or you can
get the result set plus output parameters. You can specify that params are
output.

NOTE: This is not a classic ASP group, you should publish to
microsoft.public.inetserver.asp.* instead.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside the box!
*************************************************
 
Back
Top