Index: openacs.org-dev/www/templates/homepage-index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/www/templates/homepage-index.tcl,v diff -u -r1.6 -r1.7 --- openacs.org-dev/www/templates/homepage-index.tcl 2 Aug 2002 09:09:25 -0000 1.6 +++ openacs.org-dev/www/templates/homepage-index.tcl 2 Aug 2002 09:13:19 -0000 1.7 @@ -35,15 +35,15 @@ #set user_id [ad_conn user_id] -set view_clause [db_map view_clause_live] +#set view_clause [db_map view_clause_live] db_multirow news_items news_items_select " select item_id, publish_title, pretty_publish_date from news_items_approved -where $view_clause -and package_id = 43787 +where package_id = 43787 +-- and $view_clause order by publish_date desc, item_id desc "