大侠们，帮我解决一个ASP中调用存储过程的问题，谢谢！！！代码如下

[rainhow]

CREATE PROCEDURE Select_Student
(
@vsName varchar(20),
@oName varchar(20)
)
AS
select * from student
GO

dim conn,rs,cmd,connstr
connstr="driver={SQL Server};server=(local);UID=sa;PWD=123;DATABASE=mydata"
set conn=server.createobject("adodb.connection")
set cmd=server.createobject("adodb.command")
conn.open connstr
set cmd.activeconnection=conn
cmd.commandType=4
cmd.commandText="Select_Student"
set firstparam=cmd.createparameter("vName",advarchar,adparaminput,20)
cmd.parameters.append firstparam
set secondparam=cmd.createparameter("oName",advarchar,adparamoutput,20)
cmd.parameters.append secondparam
cmd("vName")="sss"
cmd.execute
response.write cmd("oName")

[潜水的鱼]

你的存储过程没有用到参数,那就不要写参数啊

CREATE PROCEDURE Select_Student

AS
select * from student
GO

dim conn,rs,cmd,connstr
connstr="driver={SQL Server};server=(local);UID=sa;PWD=123;DATABASE=mydata"
set conn=server.createobject("adodb.connection")
set cmd=server.createobject("adodb.command")
conn.open connstr
set cmd.activeconnection=conn
cmd.commandType=4
cmd.commandText="Select_Student"
cmd.execute
response.write cmd("oName")

[despider]

CREATE PROCEDURE Select_Student
(
@vsName varchar(20),
@oName varchar(20) output --输出参数
)
AS
select * from student
GO

去掉cmd("vName")="sss"

[despider]

还有set firstparam=cmd.createparameter("vName",advarchar,adparaminput,20)改为
set firstparam=cmd.createparameter("vName",advarchar,adparaminput,20，'aaa')
估计没有报错， 但存储过程里没有给@oName赋值，所以没有输出

[xiaoyuehen]

conn.execute("Select_Student 参数, 参数")