Error Encountered:
Item cannot be found in the collection corresponding to
requested name or ordinal.
I am encoutering the above error message when i am trying to execute the sp. sp works fine when i execute in the query analyzer. I am not sure if i am calling it wrong. Any help appreciated. Thank You.
Function RetrieveJdeDate(dcnDB,sqldate)
Dim ObjCmd
Dim jdeBeginDate
Dim jdeEndDate
Dim parIDInput
Dim rsData
Dim date_conv
Set ObjCmd = Server.CreateObject("ADODB.Command")
Set ObjCmd.ActiveConnection = dcnDB
ObjCmd.CommandText = "SP_CONVERT_INTO_JDE_DATE"
ObjCmd.CommandType = adCmdStoredProc
ObjCmd.CommandTimeout = 0
Set parIDInput = ObjCmd.CreateParameter("parIDInput",adVarChar,adPa ramInput,15,sqldate)
Set jdeBeginDate = ObjCmd.CreateParameter("jdeBeginDate",adVarChar,ad ParamOutput,6)
ObjCmd.Parameters.Append parIDInput
ObjCmd.Parameters.Append jdeBeginDate
Set rsData = Server.CreateObject("ADODB.Recordset")
rsData.Cursorlocation = adUseClient
rsData.Open ObjCmd, ,adOpenStatic,adLockReadOnly,adCmdStoredProc
Set rsData = ObjCmd.Execute
RetrieveJdeDate = rsData(0)
End Function
%>