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 @@
 
   <fullquery name="get_regular_product_list">      
     <querytext>
-      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