NederlandsSequel: SELECT B.ButtonID, B.MenuID, B.Name, B.SortNr, B.DTChange, B.ButTypeID, M.ModuleID, M.FrontURL, BF.URL, BF.Code, BF.ConnectID, SUM(CASE WHEN BC.Recycle=0 AND (BC.Disabled=0 OR (BC.Disabled=2 AND (BC.DTEnable IS NULL OR BC.DTEnable<=GETDATE()) AND (BC.DTDisable IS NULL OR BC.DTDisable>GETDATE()))) AND BC.ProtectTypeID=0 THEN 1 ELSE 0 END) AS Children, SUM(CASE WHEN BP.Recycle=0 THEN 1 ELSE 0 END) AS Parents FROM ((((tblbutton AS B INNER JOIN tblbuttonframe AS BF ON B.SiteID=BF.SiteID AND B.ButtonID=BF.ButtonID) INNER JOIN tblfsetframe AS F ON BF.Code=F.Code AND BF.SiteID=F.SiteID AND B.FrameSetID=F.FrameSetID AND B.SiteID=F.SiteID) INNER JOIN tblmodule AS M ON BF.ModuleID = M.ModuleID) LEFT JOIN tblbutton AS BP ON B.SiteID=BP.SiteID AND B.ParentID=BP.ButtonID) LEFT JOIN tblbutton AS BC ON B.SiteID=BC.SiteID AND B.ButtonID=BC.ParentID WHERE 1=1 AND B.SiteID=128 AND B.MenuID=1 AND B.LangCode='NL' AND (B.Disabled=0 OR (B.Disabled=2 AND (B.DTEnable IS NULL OR B.DTEnable<=GETDATE()) AND (B.DTDisable IS NULL OR B.DTDisable>GETDATE()))) AND B.ProtectTypeID=0 AND B.Recycle=0 AND F.ExcludeSitemap=0 AND B.ButTypeID<>3 GROUP BY B.ButtonID, B.MenuID, B.Name, B.SortNr, B.DTChange, B.ButTypeID, M.ModuleID, M.FrontURL, BF.URL, BF.Code, BF.ConnectID HAVING SUM(CASE WHEN BP.Recycle=0 THEN 1 ELSE 0 END)=0 UNION SELECT B.ButtonID, B.MenuID, B.Name, B.SortNr, B.DTChange, B.ButTypeID, 0 AS ModuleID, NULL AS FrontURL, NULL AS URL, NULL AS Code, NULL AS ConnectID, SUM(CASE WHEN BC.Recycle=0 AND (BC.Disabled=0 OR (BC.Disabled=2 AND (BC.DTEnable IS NULL OR BC.DTEnable<=GETDATE()) AND (BC.DTDisable IS NULL OR BC.DTDisable>GETDATE()))) AND BC.ProtectTypeID=0 THEN 1 ELSE 0 END) AS Children, SUM(CASE WHEN BP.Recycle=0 THEN 1 ELSE 0 END) AS Parents FROM (tblbutton AS B LEFT JOIN tblbutton AS BP ON B.SiteID=BP.SiteID AND B.ParentID=BP.ButtonID) LEFT JOIN tblbutton AS BC ON B.SiteID=BC.SiteID AND B.ButtonID=BC.ParentID WHERE 1=1 AND B.SiteID=128 AND B.MenuID=1 AND B.LangCode='NL' AND (B.Disabled=0 OR (B.Disabled=2 AND (B.DTEnable IS NULL OR B.DTEnable<=GETDATE()) AND (B.DTDisable IS NULL OR B.DTDisable>GETDATE()))) AND B.ProtectTypeID=0 AND B.Recycle=0 AND B.ButTypeID=3 GROUP BY B.ButtonID, B.MenuID, B.Name, B.SortNr, B.DTChange, B.ButTypeID HAVING SUM(CASE WHEN BP.Recycle=0 THEN 1 ELSE 0 END)=0 ORDER BY SortNr, Name
Pagina: /idx/sitemap.asp
Functie: VWA_SQLOpenRecordset(coredata)
Foutnummer: -2147217900
Omschrijving: Ambiguous column name 'SortNr'.
NativeError: 209
SQL State: 42000
Omschrijving: Ambiguous column name 'Name'.
NativeError: 209
SQL State: 42000
Bron: Microsoft OLE DB Provider for SQL Server