Index: openacs-4/packages/ecommerce/www/admin/products/categories-upload-2.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/products/categories-upload-2.xql,v
diff -u -r1.3.2.1 -r1.3.2.2
--- openacs-4/packages/ecommerce/www/admin/products/categories-upload-2.xql	17 Feb 2005 11:53:16 -0000	1.3.2.1
+++ openacs-4/packages/ecommerce/www/admin/products/categories-upload-2.xql	18 Feb 2005 11:39:16 -0000	1.3.2.2
@@ -7,5 +7,32 @@
       where sku = :sku
     </querytext>
   </fullquery>
+
+  <fullquery name="subsubcategories_select">
+    <querytext>
+      select c.category_id, c.category_name, s.subcategory_id, s.subcategory_name, ss.subsubcategory_id, ss.subsubcategory_name
+      from ec_subsubcategories ss, ec_subcategories s, ec_categories c
+      where c.category_id = s.category_id
+      and s.subcategory_id = ss.subcategory_id
+      and :subsubcategory = subsubcategory_id
+    </querytext>
+  </fullquery>
+
+  <fullquery name="subcategories_select">
+    <querytext>
+      select c.category_id, c.category_name, s.subcategory_id,
+      s.subcategory_name from ec_subcategories s, ec_categories c
+      where c.category_id = s.category_id
+      and :subcategory = subcategory_id
+    </querytext>
+  </fullquery>
+
+  <fullquery name="category_match_select">      
+    <querytext>
+      select category_id, category_name 
+      from ec_categories 
+      where :category = category_id
+    </querytext>
+  </fullquery>
  
 </queryset>
Index: openacs-4/packages/ecommerce/www/admin/products/categories-upload-by-id-2.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/products/categories-upload-by-id-2.xql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/ecommerce/www/admin/products/categories-upload-by-id-2.xql	17 Feb 2005 11:51:21 -0000	1.1.2.1
+++ openacs-4/packages/ecommerce/www/admin/products/categories-upload-by-id-2.xql	18 Feb 2005 11:39:16 -0000	1.1.2.2
@@ -7,5 +7,32 @@
       where sku = :sku
     </querytext>
   </fullquery>
+
+  <fullquery name="subsubcategories_select">
+    <querytext>
+      select c.category_id, c.category_name, s.subcategory_id, s.subcategory_name, ss.subsubcategory_id, ss.subsubcategory_name
+      from ec_subsubcategories ss, ec_subcategories s, ec_categories c
+      where c.category_id = s.category_id
+      and s.subcategory_id = ss.subcategory_id
+      and :subsubcategory = subsubcategory_id
+    </querytext>
+  </fullquery>
+
+  <fullquery name="subcategories_select">
+    <querytext>
+      select c.category_id, c.category_name, s.subcategory_id,
+      s.subcategory_name from ec_subcategories s, ec_categories c
+      where c.category_id = s.category_id
+      and :subcategory = subcategory_id
+    </querytext>
+  </fullquery>
+
+  <fullquery name="category_match_select">      
+    <querytext>
+      select category_id, category_name 
+      from ec_categories 
+      where :category = category_id
+    </querytext>
+  </fullquery>
  
 </queryset>