救急!关于存储过程!谢谢啦!
有一存储过程代码如下:
Create PROC SP_FUNC_judgement
@condition varchar(10)
as
if exists(select * from TB_SystemFunction_INFO where FunctionID=@condition and Switch='1')
begin
return 1
end
if not exists(select * from TB_SystemFunction_INFO where FunctionID=@condition and Switch='1')
begin
return 0
end
网页代码如下:
set cmd = Server.CreateObject("ADODB.Command")
set cmd.ActiveConnection = cn
cmd.CommandText="SP_FUNC_judgement"
set dataParam = cmd.CreateParameter("RETURN_VALUE", adInteger, adParamReturnValue, 4)
cmd.Parameters.Append dataParam
set dataParam = cmd.CreateParameter("@condition",adVarChar,adParamInput,10,"F01")
cmd.Parameters.Append dataParam
cmd.Execute
DIMS = cmd.Parameters("RETURN_VALUE").Value
我为何取不到DIMS的数值呢?即存储过程的return值。救急呀!