Index: openacs-4/packages/lars-blogger/tcl/rss-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/rss-procs-oracle.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/lars-blogger/tcl/rss-procs-oracle.xql	11 Dec 2003 21:40:05 -0000	1.5
+++ openacs-4/packages/lars-blogger/tcl/rss-procs-oracle.xql	14 Dec 2003 11:10:44 -0000	1.6
@@ -15,15 +15,15 @@
             from (select entry_id,
                          e.title, 
                          e.content,
-                         to_char(e.posted_date, 'YYYY-MM-DD HH24:MI:SS') as posted_time_ansi,
+                         to_char(e.entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi,
                          c.name as category
                   from   pinds_blog_entries e,
                          pinds_blog_categories c
                   where  e.package_id = :package_id
                   and    e.draft_p = 'f'
                   and    e.deleted_p = 'f'
                   and    c.category_id = e.category_id (+)
-                  order  by e.entry_date desc, e.posted_date desc)
+                  order  by e.entry_date desc)
             where rownum < 11
         </querytext>
     </fullquery>
@@ -34,7 +34,7 @@
             from (select e.entry_id,
                          e.title, 
                          e.content,
-                         to_char(e.posted_date, 'YYYY-MM-DD HH24:MI:SS') as posted_time_ansi,
+                         to_char(e.entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi,
                          c.name as category
                   from   pinds_blog_entries e,
 		         acs_objects o, 
@@ -47,14 +47,14 @@
                   and    e.draft_p = 'f'
                   and    e.deleted_p = 'f'
                   and    c.category_id = e.category_id (+)
-                  order  by e.entry_date desc, e.posted_date desc)
+                  order  by e.entry_date desc)
             where rownum < 11
         </querytext>
     </fullquery>
 
     <fullquery name="lars_blog__rss_lastUpdated.get_last_update">
         <querytext>
-	        select nvl ((max(posted_date)-to_date('1970-01-01'))*60*60*24,0) as last_update
+	        select nvl ((max(entry_date)-to_date('1970-01-01'))*60*60*24,0) as last_update
 	        from   pinds_blog_entries
 	        where  package_id = :package_id
 	        and    draft_p = 'f'
@@ -64,7 +64,7 @@
 
     <fullquery name="lars_blog__rss_lastUpdated.get_last_user_update">
         <querytext>
-	        select nvl ((max(posted_date)-to_date('1970-01-01'))*60*60*24,0) as last_update
+	        select nvl ((max(entry_date)-to_date('1970-01-01'))*60*60*24,0) as last_update
 	        from   pinds_blog_entries e join
                        acs_objects o on (o.object_id = e.entry_id)
 	        where  e.package_id = :package_id