求助 ASP 中 调用存储过程 错误

[nikifeir]

dim MyComm ,mrs
Set MyComm = Server.CreateObject("ADODB.Command")
with MyComm
.ActiveConnection = conn 'conn是数据库连接字串
.CommandText = "check_user_login" '指定存储过程名
.CommandType = 4 '表明这是一个存储过程
.Prepared = true '要求将SQL命令先行编译
'入参(用户名)
.Parameters.Append .CreateParameter("@username",200,1,20,username)
'入参(密码)
.Parameters.Append .CreateParameter("@password",200,1,33,password)
Set mrs = .Execute
end with
MyComm.close
Set MyComm = nothing


执行以上代码总是会出现服务器代码有误的错误，清高手指教

[gingerkang]

with没错
MyComm.close
报错把详细错误,哪一行描述清楚

[wubaozhang]

dim MyComm ,mrs
Set MyComm = Server.CreateObject("ADODB.Command")
with MyComm
.ActiveConnection = conn 'conn是数据库连接字串
.CommandText = "check_user_login" '指定存储过程名
.CommandType = 4 '表明这是一个存储过程
.Prepared = true '要求将SQL命令先行编译
'入参(用户名)
.Parameters.Append .CreateParameter("@username",200,1,20,username)
'入参(密码)
.Parameters.Append .CreateParameter("@password",200,1,33,password)
Set mrs = MyComm.Execute
end with
MyComm.close
Set MyComm = nothing

有你这么写WITH的吗!不行就把WITH去掉先