Index: openacs-4/packages/dotlrn/www/spam.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/spam.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/dotlrn/www/spam.xql	29 Mar 2002 19:38:26 -0000	1.5
+++ openacs-4/packages/dotlrn/www/spam.xql	1 May 2002 01:19:47 -0000	1.6
@@ -1,57 +1,58 @@
 <?xml version="1.0"?>
 
 <queryset>
-  <fullquery name="select_rel_segment_id">
-    <querytext>
-      select rel_segments.segment_id
-      from rel_segments
-      where rel_segments.group_id = :community_id
-      and rel_segments.rel_type = :rel_type
-    </querytext>
-  </fullquery>
 
-  <fullquery name="select_recepients">
-    <querytext>
-      select parties.party_id
-      from party_approved_member_map,
-           parties
-      where party_approved_member_map.party_id = :segment_id
-      and party_approved_member_map.member_id <> :segment_id
-      and party_approved_member_map.member_id = parties.party_id
-    </querytext>
-  </fullquery>
+    <fullquery name="select_rel_segment_id">
+        <querytext>
+            select rel_segments.segment_id
+            from rel_segments
+            where rel_segments.group_id = :community_id
+            and rel_segments.rel_type = :rel_type
+        </querytext>
+    </fullquery>
 
-  <fullquery name="select_recepient_info">
-    <querytext>
-      select parties.email,
-             decode(acs_objects.object_type,
-                    'user',
-                    (select first_names
-                     from persons
-                     where person_id = parties.party_id),
-                    'group',
-                    (select group_name
-                     from groups
-                     where group_id = parties.party_id),
-                    'rel_segment',
-                    (select segment_name
-                     from rel_segments
-                     where segment_id = parties.party_id),
-                    '') as first_names,
-             decode(acs_objects.object_type,
-                    'user',
-                    (select last_name
-                     from persons
-                     where person_id = parties.party_id),
-                    '') as last_name
-      from party_approved_member_map,
-           parties,
-           acs_objects
-      where party_approved_member_map.party_id = :segment_id
-      and party_approved_member_map.member_id <> :segment_id
-      and party_approved_member_map.member_id = parties.party_id
-      and parties.party_id = acs_objects.object_id
-    </querytext>
-  </fullquery>
+    <fullquery name="select_recepients">
+        <querytext>
+            select parties.party_id
+            from party_approved_member_map,
+                 parties
+            where party_approved_member_map.party_id = :segment_id
+            and party_approved_member_map.member_id <> :segment_id
+            and party_approved_member_map.member_id = parties.party_id
+        </querytext>
+    </fullquery>
 
+    <fullquery name="select_recepient_info">
+        <querytext>
+            select parties.email,
+                   decode(acs_objects.object_type,
+                          'user',
+                          (select first_names
+                           from persons
+                           where person_id = parties.party_id),
+                          'group',
+                          (select group_name
+                           from groups
+                           where group_id = parties.party_id),
+                          'rel_segment',
+                          (select segment_name
+                           from rel_segments
+                           where segment_id = parties.party_id),
+                          '') as first_names,
+                   decode(acs_objects.object_type,
+                          'user',
+                          (select last_name
+                           from persons
+                           where person_id = parties.party_id),
+                          '') as last_name
+            from party_approved_member_map,
+                 parties,
+                 acs_objects
+            where party_approved_member_map.party_id = :segment_id
+            and party_approved_member_map.member_id <> :segment_id
+            and party_approved_member_map.member_id = parties.party_id
+            and parties.party_id = acs_objects.object_id
+        </querytext>
+    </fullquery>
+
 </queryset>