Index: openacs-4/packages/dotlrn/tcl/community-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/tcl/community-procs-postgresql.xql,v
diff -u -r1.4 -r1.4.2.1
--- openacs-4/packages/dotlrn/tcl/community-procs-postgresql.xql	29 Jun 2004 10:17:54 -0000	1.4
+++ openacs-4/packages/dotlrn/tcl/community-procs-postgresql.xql	27 Dec 2005 21:50:53 -0000	1.4.2.1
@@ -104,4 +104,16 @@
         </querytext>
     </fullquery>
 
+    <fullquery name="dotlrn_community::send_member_email.member_email">
+        <querytext>
+            select from_addr,
+	           subject,
+                   email
+            from dotlrn_member_emails
+            where (enabled_p or :override_enabled_p = 1)
+	          and community_id = :community_id
+	          and type = :type
+		</querytext>
+	</fullquery>
+
 </queryset>