Index: openacs-4/packages/ecommerce/www/category-browse-subcategory-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/category-browse-subcategory-oracle.xql,v diff -u -r1.1 -r1.1.8.1 --- openacs-4/packages/ecommerce/www/category-browse-subcategory-oracle.xql 13 Sep 2002 00:42:35 -0000 1.1 +++ openacs-4/packages/ecommerce/www/category-browse-subcategory-oracle.xql 28 Dec 2004 09:55:41 -0000 1.1.8.1 @@ -25,7 +25,7 @@ - select p.product_id, p.product_name, p.one_line_description, o.offer_code + select p.product_id, p.dirname, p.product_name, p.one_line_description, o.offer_code from $product_map($sub) m, ec_products_searchable p, ec_user_session_offer_codes o where (p.product_id=o.product_id(+) and (user_session_id=:user_session_id or user_session_id is null)) and p.product_id = m.product_id