Error EMRX_ProcessRxEmail: Procedure 'EMRX_ProcessRxEmail' expects parameter '@Email2', which was not supplied., Now this really stinks. I checked the calling ASP code:.ActiveConnection = Cnxn.ActiveConnection.CursorLocation = adUseClient.CommandText = "dbo.EMRX_ProcessRxEmail".CommandType = adCmdStoredProc.Parameters.Append .CreateParameter("@ClientID", adInteger, adParamInput, , intClientID).Parameters.Append .CreateParameter("@CourseID", adInteger, adParamInput, , intCourseID).Parameters.Append .CreateParameter("@xEmailSendDate", adVarchar, adParamInput, 100, mailDate).Parameters.Append .CreateParameter("@xEmailSubject", adVarChar, adParamInput, 200, mailSubject).Parameters.Append .CreateParameter("@xEmailFromAddress", adVarChar, adParamInput, 100, mailFromAddress).Parameters.Append .CreateParameter("@xEmailTo", adVarChar, adParamInput, 100, mailTo).Parameters.Append .CreateParameter("@xEmailBody", adVarChar, adParamInput, 2000, mailBodyText).Parameters.Append .CreateParameter("@Email1", adVarChar, adParamInput, 100, strEmail1).Parameters.Append .CreateParameter("@Email2", adVarChar, adParamInput, 100, strEmail2).Execute ,,adExecuteNoRecordsObviously @Email2 is supplied, and this code has run properly for years now, until one day, when an email arrived with an attachment.Anyone have a guess as to why this error might be generated when the email has an attachment?Sam
Error EMRX_ProcessRxEmail:
Posted - 2005-04-27 : 11:22:45
