Index: openacs-4/packages/ecommerce/www/mailing-list-add.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/mailing-list-add.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/ecommerce/www/mailing-list-add.xql 10 Jul 2001 20:42:02 -0000 1.1 +++ openacs-4/packages/ecommerce/www/mailing-list-add.xql 26 May 2002 04:36:50 -0000 1.2 @@ -1,53 +1,61 @@ + - - - select first_names || ' ' || last_name as user_name from cc_users where user_id=:user_id - - + + + select first_names || ' ' || last_name as user_name + from cc_users + where user_id=:user_id + + - - - - select category_name from ec_categories where category_id=:category_id - - + + + select category_name + from ec_categories + where category_id=:category_id + + - - - - select category_name from ec_categories where category_id=:category_id - - + + + select category_name + from ec_categories + where category_id=:category_id + + - - - - select subcategory_name from ec_subcategories where subcategory_id=:subcategory_id - - + + + select subcategory_name + from ec_subcategories + where subcategory_id=:subcategory_id + + - - - - select category_name from ec_categories where category_id=:category_id - - + + + select category_name + from ec_categories + where category_id=:category_id + + - - - - select subcategory_name from ec_subcategories where subcategory_id=:subcategory_id - - + + + select subcategory_name + from ec_subcategories + where subcategory_id=:subcategory_id + + - - - - select subsubcategory_name from ec_subsubcategories where subsubcategory_id=:subsubcategory_id - - + + + select subsubcategory_name + from ec_subsubcategories + where subsubcategory_id=:subsubcategory_id + + -