Index: openacs-4/packages/ecommerce/www/mailing-list-add-2.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/mailing-list-add-2.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/mailing-list-add-2.xql	10 Jul 2001 20:42:02 -0000	1.1
+++ openacs-4/packages/ecommerce/www/mailing-list-add-2.xql	26 May 2002 04:36:50 -0000	1.2
@@ -1,46 +1,53 @@
 <?xml version="1.0"?>
+
 <queryset>
 
-<fullquery name="get_list_name">      
-      <querytext>
-      select category_name from ec_categories where category_id=:category_id
-      </querytext>
-</fullquery>
+  <fullquery name="get_list_name">      
+    <querytext>
+      select category_name 
+      from ec_categories
+      where category_id=:category_id
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="get_mailing_list_name">      
-      <querytext>
-      select category_name from ec_categories where category_id=:category_id
-      </querytext>
-</fullquery>
+  <fullquery name="get_mailing_list_name">      
+    <querytext>
+      select category_name 
+      from ec_categories
+      where category_id=:category_id
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="get_subcat_listname">      
-      <querytext>
-      select subcategory_name from ec_subcategories where subcategory_id=:subcategory_id
-      </querytext>
-</fullquery>
+  <fullquery name="get_subcat_listname">      
+    <querytext>
+      select subcategory_name 
+      from ec_subcategories
+      where subcategory_id=:subcategory_id
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="get_category_name">      
-      <querytext>
-      select category_name from ec_categories where category_id=:category_id
-      </querytext>
-</fullquery>
+  <fullquery name="get_category_name">      
+    <querytext>
+      select category_name 
+      from ec_categories
+      where category_id=:category_id
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="get_subcategory_name">      
-      <querytext>
-      select subcategory_name from ec_subcategories where subcategory_id=:subcategory_id
-      </querytext>
-</fullquery>
+  <fullquery name="get_subcategory_name">      
+    <querytext>
+      select subcategory_name 
+      from ec_subcategories
+      where subcategory_id=:subcategory_id
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="get_subsubcategory_name">      
-      <querytext>
-      select subsubcategory_name from ec_subsubcategories where subsubcategory_id=:subsubcategory_id
-      </querytext>
-</fullquery>
+  <fullquery name="get_subsubcategory_name">      
+    <querytext>
+      select subsubcategory_name 
+      from ec_subsubcategories
+      where subsubcategory_id=:subsubcategory_id
+    </querytext>
+  </fullquery>
 
- 
 </queryset>