请帮忙看看这个调用错哪儿哪？为什么cmd显示状态为关闭

[kaka1978]

<%
dim str
set cmd=server.CreateObject("ADODB.Command")

str = "{call MsMsgPack1.SelectMsProduct1({resultset 100,themsg,thescts})}"
With cmd
.CommandText = str
.ActiveConnection = conn
.CommandType = 4
'.Parameters.Append cmd.CreateParameter("m_da",200,1,15,request.Form("ms"))
'.Parameters.Append cmd.CreateParameter("m_scts",7,1,,request.Form("datename"))
End With

rs.CursorLocation = 3'adUseClient
'response.Write(cmd.State)
rs.Open cmd 《----------------------这里报错
'Do While Not rs.EOF
' Debug.Print rs.Fields(0).Value & vbTab & rs.Fields(1).Value
' rs.MoveNext
'Loop
set cmd = nothing
%>

[kaka1978]

不好意思，我用的是oracle的存储过程调用

• 打赏
• 举报

回复 赞

[sheng9hhd]

Set rs = cmd.Execute()

• 打赏
• 举报

回复 赞

[kaka1978]

不对的

• 打赏
• 举报

回复 赞

[postfix2]

aa=request("txt1")
bb=request("txt2")
set cmd=server.createobject("adodb.command")
set cmd.activeconnection=conn
cmd.commandtype=4
cmd.commandtext="sp_userlogo"
set tmp1=cmd.createparameter("userid",200,1,50)
cmd.parameters.append tmp1
set tmp2=cmd.createparameter("userpwd",200,1,50)
cmd.parameters.append tmp2
set tmp3=cmd.createparameter("retvalue",200,2,80)
cmd.parameters.append tmp3
set tmp4=cmd.createparameter("retcount",200,2,80)
cmd.parameters.append tmp4
cmd("userid")=aa
cmd("userpwd")=bb
cmd.execute
tmp4=cmd("retcount")
tmp5=cmd("retvalue")
response.write tmp5
response.write tmp4

• 打赏
• 举报

回复 赞

[postfix2]

上边是我调用存储过程判断用户登陆的例子，返回存储过程的值:



CREATE proc sp_userlogo
(
@userid nvarchar(20),
@userpwd nvarchar(30),
@retvalue int output,
@retcount int output
)
as
declare @flag int
declare @count int
if exists(select * from userid where userid=@userid and userpwd=@userpwd)
set @flag=1
else
set @flag=0


if @flag=1
begin
if exists(select * from userid where paymoney=1 and userid=@userid)
set @flag=3
else
set @flag=2
end

select @count=logocount from userid where userid=@userid
if @flag=3 and @count>0
update userid set logocount=logocount+1 where userid=@userid


set @retvalue=@flag
select @retcount=logocount from userid where userid=@userid


GO

exec sp_userlogo 'username','userpwd',1,2

• 打赏
• 举报

回复 赞

[kaka1978]

问题解决，感谢参与

• 打赏
• 举报

回复 赞