请大虾们帮忙(调用存储过程)

[zwei3000]

我的存储过程
create procudure proc_inserts
@id int,
@name varchar(50),
@err varchar(50)
as
if exists(select * from user where userid=@id and name like @name)
select @err='成功!'
else
select @err='失败'
go

我在ASP文件中调用存储过程:
var conn=new CDBConnection();
var comm=Server.CreateObject("adodb.command");
comm.ActiveConnection=conn.Connection;
comm.CommandType=adCmdStoredProc;
comm.CommandText="proc_inserts";
var tempFirstParam=comm.CreateParameter("@id",adInteger,adParamInput,4);
comm.Parameters.Append(tempFirstParam);
var tempSecondParam=comm.CreateParameter("@name",adVarChar,adParamInput,50);
comm.Parameters.Append(tempSecondParam);
var tempThirdParam=comm.CreateParameter("@err",adInteger,adParamOutput,50);
comm.Parameters.Append(tempThirdParam);
comm("@id")=1;
comm("@name")="jackie";
comm.Excute;
Response.Write(comm.Parameters("@err").Value);


浏览器上什么东西都没有,我怎么取得返回值呢??

[river168]

create procudure proc_inserts
@id int,
@name varchar(50),
@err varchar(50) out
as

[river168]

create procudure proc_inserts
@id int,
@name varchar(50),
@err varchar(50) output
as

[zwei3000]

多谢提醒,我把我的存储过程改成了
create procudure proc_inserts
@id int,
@name varchar(50),
@err varchar(50) output
as
if exists(select * from user where userid=@id and name like @name)
select @err='成功!'
else
select @err='失败'
go
在查询分析器中运行,没有问题了,不过用ASP调用,浏览器还是空白的,郁闷.......

[tigerwen01]

没有返回参数
create procudure proc_inserts
@id int,
@name varchar(50),
@err varchar(50) output --定义返回参数
as
if exists(select * from user where userid=@id and name like @name)
select @err='成功!'
else
select @err='失败'
go

[river168]

var tempSecondParam=comm.CreateParameter("@name",adVarChar,adParamInput,50);
comm.Parameters.Append(tempSecondParam);
var tempThirdParam=comm.CreateParameter("@err",adVarChar,adParamOutput,50);

[river168]

'var tempThirdParam=comm.CreateParameter("@err",adInteger,adParamOutput,50);
var tempThirdParam=comm.CreateParameter("@err",adVarChar,adParamOutput,50);