[DataConnection.HandleError]:
Query:
SELECT a.SpecialtyId,a.SubSpecialtyId,b.NameJapan AS SpecialtyName,c.NameJapan AS SubSpecialtyName FROM tblDoctorSpecialty a INNER JOIN tblSpecialty b ON a.SpecialtyId = b.Id LEFT JOIN tblSubSpecialty c on a.SubSpecialtyId = c.Id WHERE DocId = @docID
Caused exception:
Must declare the scalar variable "@docID".
| at CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, Exception ex)
at CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)
at CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query)
at CMS.DataEngine.GeneralConnection.RunQueryWithRetry(QueryParameters query, Int32 retryCount)
at BIH.CMS.Database.Utility.CMSSqlHelper.ExecuteQuery(String sqlCommand, CMSParameter parameter)
1
*Click on the specialty of interest below to see the list of doctors: