8.0w+
社区成员
请大家帮助我检查一下，下面调用存储过程的方法错在哪里？
set Cmd = Server.CreateObject("ADODB.Command")
Cmd.ActiveConnection=conn
Cmd.CommandText="p_ckgjpm"
Cmd.CommandType=&H0004
Cmd.Parameters.Refresh
set parmqsrq=cmd.CreateParameter("qsrq",adDate,adParamInput,,"1999-1-1")
cmd.Parameters.append parmqsrq
set parmzzrq=cmd.CreateParameter("zzrq",adDate,adParamInput,,"2001-12-12")
cmd.Parameters.append parmzzrq
set parmgsbm=cmd.CreateParameter("gsbm",.adChar,adParamInput,,"0000")
cmd.Parameters.append parmgsbm
会提示：Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.为什么？
Cmd.ActiveConnection=conn
Cmd.CommandText="p_ckgjpm"
Cmd.CommandType=&H0004
Cmd.Parameters.Refresh
set parmqsrq=cmd.CreateParameter("qsrq",adDate,adParamInput,,"1999-1-1")
cmd.Parameters.append parmqsrq
set parmzzrq=cmd.CreateParameter("zzrq",adDate,adParamInput,,"2001-12-12")
cmd.Parameters.append parmzzrq
set parmgsbm=cmd.CreateParameter("gsbm",.adChar,adParamInput,,"0000")
cmd.Parameters.append parmgsbm
会提示：Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.为什么？
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
s_octopus 2001-09-19
set parmqsrq=cmd.CreateParameter("qsrq",adDate,adParamInput,,"1999-1-1")
~~~日期类型是不可以直接这样输入的，要转换的。
~~~日期类型是不可以直接这样输入的，要转换的。
