求助:关于存储过程的问题,高手请进!!!!!

[quweiie]

数据库:SQL Server2000
使用的是［pubs］数据库里的titles表创建的Stored Procedure:
CREATE proc MyProc
(
@price smallint,
@out smallint OUTPUT
)
AS
Select @out = count(*) from titles where price < @price
GO
**********************************************************************
xml.asp:
<%
Dim cmd
Dim ln
Dim retCount

Set cmd = Server.CreateObject("ADODB.Command")

With cmd
.ActiveConnection = "Paste your connection string here"
.Commandtext = "MyProc"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("@price", adSmallInt, adParamInput, 10)
.Parameters("@price") = 22
.Parameters.Append .CreateParameter("@retValue", adSmallInt, adParamOutput, 10)
.Execute ln, , adExecuteNoRecords
retCount = .Parameters("@retValue")
End with

Response.Write retcount

Set cmd = Nothing
%>
请问是哪儿出错了？请指点！！

[quweiie]

.Execute ln, , adExecuteNoRecords
这句话,能给我解释一下吗?

[quweiie]

对了我的数据库是连接上了
<!--#include file="connsql.asp"-->
ActiveConnection = conn