[Error loading the control 'ArticleList', check event log for more details]
[DataConnection.HandleError]:
Query:
SELECT * FROM
(
SELECT *, ROW_NUMBER() OVER (ORDER BY STT ASC) AS CMS_ORN, ROW_NUMBER() OVER (PARTITION BY DocumentNodeID, NodeLinkedNodeID ORDER BY CASE WHEN DocumentCulture = @DocumentCulture THEN 1 ELSE 2 END) AS CMS_C FROM View_CONTENT_Job_Joined WHERE NodeSiteID = @NodeSiteID AND (Published = @Published AND (NodeAliasPath LIKE N'/kkk/Nghien-cuu-trao-đoi/DS-doanh-nghiep-đa-đang-ky/%') AND DocumentCulture = @DocumentCulture)
)
AS SubData
WHERE CMS_C = @CMS_C ORDER BY CMS_ORN
Caused exception:
Invalid column name 'STT'.
[Error loading the control 'ArticleList1', check event log for more details]
[DataConnection.HandleError]:
Query:
SELECT * FROM
(
SELECT *, ROW_NUMBER() OVER (ORDER BY STT ASC) AS CMS_ORN, ROW_NUMBER() OVER (PARTITION BY DocumentNodeID, NodeLinkedNodeID ORDER BY CASE WHEN DocumentCulture = @DocumentCulture THEN 1 ELSE 2 END) AS CMS_C FROM View_CONTENT_Job_Joined WHERE NodeSiteID = @NodeSiteID AND (Published = @Published AND (NodeAliasPath LIKE N'/kkk/Nghien-cuu-trao-đoi/DS-doanh-nghiep-bi-giai-the/%') AND DocumentCulture = @DocumentCulture)
)
AS SubData
WHERE CMS_C = @CMS_C ORDER BY CMS_ORN
Caused exception:
Invalid column name 'STT'.
[Error loading the control 'ArticleList2', check event log for more details]
[DataConnection.HandleError]:
Query:
SELECT * FROM
(
SELECT *, ROW_NUMBER() OVER (ORDER BY STT ASC) AS CMS_ORN, ROW_NUMBER() OVER (PARTITION BY DocumentNodeID, NodeLinkedNodeID ORDER BY CASE WHEN DocumentCulture = @DocumentCulture THEN 1 ELSE 2 END) AS CMS_C FROM View_CONTENT_Job_Joined WHERE NodeSiteID = @NodeSiteID AND (Published = @Published AND (NodeAliasPath LIKE N'/kkk/Nghien-cuu-trao-đoi/DS-doanh-nghiep-bi-thu-hoi-CN-ĐKKD/%') AND DocumentCulture = @DocumentCulture)
)
AS SubData
WHERE CMS_C = @CMS_C ORDER BY CMS_ORN
Caused exception:
Invalid column name 'STT'.
|