存储过程的返加值的问题。^_^

[jack_fang]

CREATE PROCEDURE proc_checkstatus
@ids int,
@Password varchar(50)
AS
if exists (select * from info where id=@ids and sPassword=@Password)
begin
select iStatus from status where Id=@ids
end
GO

请问在asp中怎么取得返回的值?

[loulou_ff]

http://blog.csdn.net/loulou_ff/archive/2006/03/23/635847.aspx

http://blog.csdn.net/loulou_ff/archive/2006/04/12/660612.aspx

[sky0120]

CREATE PROCEDURE proc_checkstatus
@ids int,
@Password varchar(50),
@iStatus int output
AS
if exists (select * from info where id=@ids and sPassword=@Password)
begin
select @iStatus=iStatus from status where Id=@ids
end
GO

[sky0120]

Set Cmd=Server.CreateObject("ADODB.Command")
Set Cmd.ActiveConnection=myconn
Cmd.CommandTimeOut=30
Cmd.CommandType=4
Cmd.CommandText="proc_checkstatus"

'设置Cmd对象的参数
Cmd.Parameters.Append Cmd.CreateParameter("Title",3,1,4,ids)
Cmd.Parameters.Append Cmd.CreateParameter("Password ",200,1,50,Password)
Cmd.Parameters.Append Cmd.CreateParameter("iStatus",3,2)
Cmd.Execute()

iStatus =Cmd.Parameters("iStatus")

[jack_fang]

结贴，绐分