Index: openacs-4/packages/acs-mail/sql/oracle/acs-mail-nt-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/oracle/acs-mail-nt-create.sql,v diff -u -N -r1.3 -r1.4 --- openacs-4/packages/acs-mail/sql/oracle/acs-mail-nt-create.sql 1 Sep 2001 02:46:33 -0000 1.3 +++ openacs-4/packages/acs-mail/sql/oracle/acs-mail-nt-create.sql 3 Sep 2001 05:28:28 -0000 1.4 @@ -165,7 +165,7 @@ ); -- get the sender email address - select email into v_header_from + select max(email) into v_header_from from parties where party_id = party_from; -- get the recipient email address