[Aplaws-commit] r903 - trunk/ccm-cms-types-newsitem/pdl/com/arsdigita/content-types

[<ap...@vh...>]

Author: apevec
Date: 2005-09-22 08:20:11 +0200 (Thu, 22 Sep 2005)
New Revision: 903

Modified:
   trunk/ccm-cms-types-newsitem/pdl/com/arsdigita/content-types/NewsItem.pdl
Log:
SF patch [ 1155903 ] Amendment to query to get Recent News
    rewritten in SQL92 syntax, which works on both PostgreSQL and Oracle >=9i


Modified: trunk/ccm-cms-types-newsitem/pdl/com/arsdigita/content-types/NewsItem.pdl
===================================================================
--- trunk/ccm-cms-types-newsitem/pdl/com/arsdigita/content-types/NewsItem.pdl	2005-09-22 05:57:11 UTC (rev 902)
+++ trunk/ccm-cms-types-newsitem/pdl/com/arsdigita/content-types/NewsItem.pdl	2005-09-22 06:20:11 UTC (rev 903)
@@ -37,11 +37,12 @@
     BigDecimal newsID;
     do {
         select n.item_id
-        from ct_news n, cms_items i, cms_article_image_map m
+        from ct_news n, cms_items i
+            left join cms_article_image_map m
+            on i.item_id = m.article_id
         where n.is_homepage = 1
         and n.item_id = i.item_id
         and i.version = 'live'
-        and n.item_id = m.article_id
         order by n.news_date desc
     } map {
         newsID = n.item_id;