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.4 -r1.5
--- openacs-4/packages/ecommerce/www/admin/products/categories-upload-2.xql	24 Feb 2005 13:33:15 -0000	1.4
+++ openacs-4/packages/ecommerce/www/admin/products/categories-upload-2.xql	28 Apr 2008 12:28:04 -0000	1.5
@@ -8,30 +8,30 @@
     </querytext>
   </fullquery>
 
-  <fullquery name="subsubcategories_select">
+  <fullquery name="find_subsubcategory">
     <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
+      and :category_match = lower(subsubcategory_name)
     </querytext>
   </fullquery>
 
-  <fullquery name="subcategories_select">
+  <fullquery name="find_subcategory">
     <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
+      and :category_match = lower(subcategory_name)
     </querytext>
   </fullquery>
 
-  <fullquery name="category_match_select">      
+  <fullquery name="find_category">      
     <querytext>
       select category_id, category_name 
       from ec_categories 
-      where :category = category_id
+      where :category_match = lower(category_name)
     </querytext>
   </fullquery>