各位大虾好,今天碰到一问题 如题...
在数据库中传入参数,可以返回正确的输出,就是不返回给asp程序 上代码:
set CmdSP = Server.CreateObject("ADODB.Command")
CmdSP.ActiveConnection = "Provider=SQLOLEDB;Data Source=10.6.100.48;User ID=WebUser;Password=KEBweb123;Initial Catalog=HR50"
CmdSP.CommandText = "ArrShiftOrConWork_CAL_BY_CODE"
CmdSP.CommandType = 4
CmdSP.Parameters.Append CmdSP.CreateParameter("@FormCode",adVarChar,adParamInput,20,arrformcode)
CmdSP.Parameters.Append CmdSP.CreateParameter("@start_day",adDate,adParamInput,20,arr(arrangecount*2-1))
CmdSP.Parameters.Append CmdSP.CreateParameter("@end_day",adDate,adParamInput,20,arr(0))
CmdSP.Parameters.Append CmdSP.CreateParameter("@Where",adVarChar,adParamInput,4000,wherestr)
CmdSP.Parameters.Append CmdSP.CreateParameter("@IsOverTime",adInteger,adParamOutput)
在数据库中传入参数,可以返回正确的输出,就是不返回给asp程序 上代码:
set CmdSP = Server.CreateObject("ADODB.Command")
CmdSP.ActiveConnection = "Provider=SQLOLEDB;Data Source=10.6.100.48;User ID=WebUser;Password=KEBweb123;Initial Catalog=HR50"
CmdSP.CommandText = "ArrShiftOrConWork_CAL_BY_CODE"
CmdSP.CommandType = 4
CmdSP.Parameters.Append CmdSP.CreateParameter("@FormCode",adVarChar,adParamInput,20,arrformcode)
CmdSP.Parameters.Append CmdSP.CreateParameter("@start_day",adDate,adParamInput,20,arr(arrangecount*2-1))
CmdSP.Parameters.Append CmdSP.CreateParameter("@end_day",adDate,adParamInput,20,arr(0))
CmdSP.Parameters.Append CmdSP.CreateParameter("@Where",adVarChar,adParamInput,4000,wherestr)
CmdSP.Parameters.Append CmdSP.CreateParameter("@IsOverTime",adInteger,adParamOutput)