Index: openacs-4/packages/ecommerce/www/admin/mailing-lists/member-add.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/mailing-lists/member-add.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/admin/mailing-lists/member-add.xql	11 Jul 2001 03:42:35 -0000	1.1
@@ -0,0 +1,15 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="get_user_info">      
+      <querytext>
+      
+select user_id, first_names, last_name, email
+  from cc_users
+ where $last_bit_of_query
+
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/admin/mailing-lists/member-remove-2.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/mailing-lists/member-remove-2.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/admin/mailing-lists/member-remove-2.xql	11 Jul 2001 03:42:35 -0000	1.1
@@ -0,0 +1,25 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="delete_from_mailing_lists">      
+      <querytext>
+      delete from ec_cat_mailing_lists where user_id=:user_id and subsubcategory_id=:subsubcategory_id
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="delete_from_mailing_lists_2">      
+      <querytext>
+      delete from ec_cat_mailing_lists where user_id=:user_id and subcategory_id=:subcategory_id and subsubcategory_id is null
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="delete_just_from_category">      
+      <querytext>
+      delete from ec_cat_mailing_lists where user_id=:user_id and category_id is null
+      </querytext>
+</fullquery>
+
+ 
+</queryset>