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 + + + + 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 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 + + + + + + select category_id, category_name + from ec_categories + where :category = category_id + + 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 + + + + 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 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 + + + + + + select category_id, category_name + from ec_categories + where :category = category_id + +