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.2 -r1.3
--- openacs-4/packages/ecommerce/www/admin/products/categories-upload-2.xql	26 May 2002 04:36:50 -0000	1.2
+++ openacs-4/packages/ecommerce/www/admin/products/categories-upload-2.xql	8 Mar 2004 19:46:14 -0000	1.3
@@ -1,20 +1,30 @@
 <?xml version="1.0"?>
 <queryset>
 
-  <fullquery name="subcategories_select">      
+  <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 upper(:category) like upper(subcategory_name)
+      and :subcategory = subcategory_id
     </querytext>
   </fullquery>
-  
+
   <fullquery name="category_match_select">      
     <querytext>
       select category_id, category_name 
       from ec_categories 
-      where upper(:category) like upper(category_name)
+      where :category = category_id
     </querytext>
   </fullquery>