Index: openacs-4/packages/ecommerce/www/sitemap.xml.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/sitemap.xml.tcl,v diff -u -r1.2 -r1.3 --- openacs-4/packages/ecommerce/www/sitemap.xml.tcl 19 Oct 2008 12:33:25 -0000 1.2 +++ openacs-4/packages/ecommerce/www/sitemap.xml.tcl 19 Oct 2008 20:36:56 -0000 1.3 @@ -2,7 +2,10 @@ set sitemap_xml " \n" -set sitemap_list [db_list_of_lists get_catalog_products "select product_id, last_modified from ec_products where active_p='t' and present_p = 't' order by last_modified desc limit 100"] +set sitemap_list [db_list_of_lists get_catalog_products " + select product_id, last_modified from ec_products + where active_p='t' and present_p = 't' + order by last_modified desc"] foreach url_pair $sitemap_list { set product_id [lindex $url_pair 0]