求救:ASP执行带OUTPUT参数的存储过程没有返回!!!!
ASP执行带OUTPUT参数的存储过程没有返回!!!!
请高手帮帮我阿,,,
我调试了一天了,没有看出是怎么回事,都郁闷死掉了,下面是我的存储过程和ASP
<%
Set DataConn = Server.CreateObject("ADODB.Connection") '建立连接对象
DataConn.Open "DSN=generali;uid=sa;pwd=111111"
Set DataCmd = Server.CreateObject("ADODB.Command")
DataCmd.ActiveConnection = DataConn
DataCmd.CommandText = "img_getuwttask"
DataCmd.CommandType = 4
Set prm= DataCmd.CreateParameter("@fileid",3,2) '整型,OUTPUT
DataCmd.Parameters.Append prm
Set rs = DataCmd.execute()
applyno= DataCmd("@fileid").Value
%>
结果取出来参数值是null,
我的存储过程是:
CREATE PROCEDURE img_getuwttask
@fileid int OUTPUT
AS
select @fileid=900
GO