Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/ecommerce/www/admin/products/categories-upload-2-oracle.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
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 -r1.3.2.1
--- openacs-4/packages/ecommerce/www/admin/products/categories-upload-2.xql	8 Mar 2004 19:46:14 -0000	1.3
+++ openacs-4/packages/ecommerce/www/admin/products/categories-upload-2.xql	17 Feb 2005 11:53:16 -0000	1.3.2.1
@@ -1,31 +1,11 @@
 <?xml version="1.0"?>
 <queryset>
 
-  <fullquery name="subsubcategories_select">
+  <fullquery name="product_check">      
     <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
+      select product_id from ec_products 
+      where sku = :sku
     </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>