UC知道ASP调用存储过程的问题?
来源：百度知道 编辑：UC知道 时间：2024/05/21 13:58:42
我用ASP调用存储过程SP_HZB.但是在网页中查询时就是查不出来,我的代码是:
<%
if request("b1") = "查询" then
session.contents("ddate1") = request("ddate1")
session.contents("ddate2") = request("ddate2")
session.contents("netno") = request("netno")
session.contents("spno") = request("spno")
end if
const adInteger = 3
const adParamInput = 1
const adVarchar = 200
const adParamReturn = 4
const adDouble = 6
set comm = server.CreateObject("ADOdb.Command")
comm.ActiveConnection = conn '数据库的连接对象
comm.CommandType = 4 '执行command的类型
comm.CommandText = "sp_hzb" '存储过程的名称
comm.Parameters.Append comm.CreateParameter("@ddate0", adVarchar, adParamInput, 50, session.contents("ddate1"))
comm.Par
<%
if request("b1") = "查询" then
session.contents("ddate1") = request("ddate1")
session.contents("ddate2") = request("ddate2")
session.contents("netno") = request("netno")
session.contents("spno") = request("spno")
end if
const adInteger = 3
const adParamInput = 1
const adVarchar = 200
const adParamReturn = 4
const adDouble = 6
set comm = server.CreateObject("ADOdb.Command")
comm.ActiveConnection = conn '数据库的连接对象
comm.CommandType = 4 '执行command的类型
comm.CommandText = "sp_hzb" '存储过程的名称
comm.Parameters.Append comm.CreateParameter("@ddate0", adVarchar, adParamInput, 50, session.contents("ddate1"))
comm.Par
不知道你的数据类型，无法判断
const adInteger = 3 整形
const adParamInput = 1 输入参数
const adVarchar = 200 字符型
const adParamReturn = 4 输出参数
const adDouble = 6 双精度型
你也可这么写
comm.Parameters.Append comm.CreateParameter("@ddate0", 200, 1, 50, session.contents("ddate1"))
就表示ddate0是一个字符型的输入参数，长度为50,它的值为session.contents("ddate1"))