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 -r1.4 -r1.4.2.1 --- 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 13 May 2004 15:31:51 -0000 1.4.2.1 @@ -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 Index: openacs-4/packages/weblogger-portlet/www/weblogger-portlet-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/weblogger-portlet/www/weblogger-portlet-postgresql.xql,v diff -u -r1.4 -r1.4.2.1 --- openacs-4/packages/weblogger-portlet/www/weblogger-portlet-postgresql.xql 11 Dec 2003 21:40:15 -0000 1.4 +++ openacs-4/packages/weblogger-portlet/www/weblogger-portlet-postgresql.xql 13 May 2004 15:31:51 -0000 1.4.2.1 @@ -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 left outer join pinds_blog_entries e on (e.package_id = p.package_id) join @@ -24,7 +24,7 @@ and e.entry_date > current_timestamp - interval '30 days' 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, e.entry_date desc