Index: openacs-4/packages/weblogger-portlet/www/weblogger-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/weblogger-portlet/www/weblogger-portlet-oracle.xql,v
diff -u -N -r1.4 -r1.5
--- openacs-4/packages/weblogger-portlet/www/weblogger-portlet-oracle.xql	11 Dec 2003 21:40:15 -0000	1.4
+++ openacs-4/packages/weblogger-portlet/www/weblogger-portlet-oracle.xql	17 May 2004 15:15:27 -0000	1.5
@@ -14,7 +14,7 @@
                            e.content,
 		           u.first_names as poster_first_names,
 		           u.last_name as poster_last_name,
-		           to_char(e.posted_date , 'HH24:MI') as posted_time_pretty,
+		           to_char(e.entry_date , 'HH24:MI') as posted_time_pretty,
                            p.package_id
 		    from   apm_packages p,
                            pinds_blog_entries e,
@@ -26,7 +26,7 @@
 		    and    u.user_id (+) = o.creation_user 
 		    and    e.draft_p (+) = 'f'
 		    and    e.deleted_p (+) = 'f'
-		    order  by p.package_id asc, e.entry_date desc, e.posted_date desc
+		    order  by p.package_id asc, e.entry_date desc
         </querytext>
     </fullquery>