[Error loading the FormControl 'dropdownlist']
[DataConnection.HandleError]:
Query:
SELECT valData,Title, Hospital, HospitalName FROM (SELECT NULL valData,
N'الطبيب'
as Title,'' as HospitalName,'' as Hospital, 0 AS SORTORDER
UNION
SELECT DD.Title valData, DD.TITLE, DH.Title as HospitalName,Hospital, 1 AS SORTORDER
FROM View_CMS_Tree_Joined_Publish V
INNER JOIN DXH_Doctors DD ON V.DocumentForeignKeyValue=DD.DoctorsID
INNER JOIN DXH_Hospital DH ON DD.Hospital = DH.HospitalID
INNER JOIN View_CMS_Tree_Joined_Publish V1 ON V1.DocumentForeignKeyValue=Dh.HospitalID AND V1.ClassName='DXH.Hospital' AND V1.DocumentCulture = V.DocumentCulture
WHERE V.ClassName='DXH.Doctors' AND V.DocumentCulture = 'ar-AE' AND V.Published = 1
and V.DocumentModifiedWhen > dateadd(dd,-180, GETDATE())
and DD.Hospital=
) AS Doctors
ORDER BY SORTORDER, Title
Caused exception:
Incorrect syntax near ')'.
[Error loading the FormControl 'dropdownlist']
[DataConnection.HandleError]:
Query:
SELECT valData,Title, Hospital, HospitalName FROM (SELECT NULL valData,
N'الطبيب'
as Title,'' as HospitalName,'' as Hospital, 0 AS SORTORDER
UNION
SELECT DD.Title valData, DD.TITLE, DH.Title as HospitalName,Hospital, 1 AS SORTORDER
FROM View_CMS_Tree_Joined_Publish V
INNER JOIN DXH_Doctors DD ON V.DocumentForeignKeyValue=DD.DoctorsID
INNER JOIN DXH_Hospital DH ON DD.Hospital = DH.HospitalID
INNER JOIN View_CMS_Tree_Joined_Publish V1 ON V1.DocumentForeignKeyValue=Dh.HospitalID AND V1.ClassName='DXH.Hospital' AND V1.DocumentCulture = V.DocumentCulture
WHERE V.ClassName='DXH.Doctors' AND V.DocumentCulture = 'ar-AE' AND V.Published = 1
and V.DocumentModifiedWhen > dateadd(dd,-180, GETDATE())
and DD.Hospital=
) AS Doctors
ORDER BY SORTORDER, Title
Caused exception:
Incorrect syntax near ')'.