asp 存贮过程 (SQL版asp调用存储过程)(2)

cmd.Parameters.Append cmd.CreateParameter("@username ",200)
cmd.Parameters.Append cmd.CreateParameter("@password",200)

cmd("@community_id")=session("community_id")
cmd("@username")=request("userid")
cmd("@password")=request("userid")

cmd.execute

dim result

result=cmd("@result")

conn.close

if trim(result)="1" then


'''''''''''''登录成功的提示与操作

else

''''''''''''''''''''''登录失败的提示与操作

end if