关于存储变量的问题!
代码如下:
<%
Set rs=Server.CreateObject("ADODB.Recordset")
set cmd=Server.CreateObject ("ADODB.Command")
set conn=Server.CreateObject ("ADODB.Connection")
set prm=Server.CreateObject ("ADODB.Parameter")
conn.Open "driver={SQL Server};server={server};uid=sa;pwd=;database=dgmis"
Set cmd.ActiveConnection = conn
cmd.CommandText = "sp_FcAnalyse"
cmd.CommandType = 4
Set prm = cmd.CreateParameter("@strBeginDate", adChar, 2, 10, strBeginDate)
cmd.Parameters.Append prm
Set prm = cmd.CreateParameter("@strEndDate", adChar, 2, 10, strEndDate)
cmd.Parameters.Append prm
rs.Open Cmd, , adOpenStatic, adLockReadOnly
Set ListForFcAnalyse = rs.getrows
rs.close
%>
报错:cmd.Parameters.Append prm----这一行
ADODB.Parameters (0x800A0E7C)
Parameter object is improperly defined. Inconsistent or incomplete information was provided.
谁能告诉我,是什么原因。怎么解决?谢谢。