Index: openacs-4/packages/bulk-mail/tcl/bulk-mail-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/tcl/bulk-mail-procs-oracle.xql,v diff -u -r1.1.1.1.2.1 -r1.1.1.1.2.2 --- openacs-4/packages/bulk-mail/tcl/bulk-mail-procs-oracle.xql 18 Dec 2002 20:06:39 -0000 1.1.1.1.2.1 +++ openacs-4/packages/bulk-mail/tcl/bulk-mail-procs-oracle.xql 23 Jun 2003 19:44:30 -0000 1.1.1.1.2.2 @@ -22,8 +22,9 @@ select bulk_mail_messages.* from bulk_mail_messages - where bulk_mail_messages.sent_p = 'f' + where bulk_mail_messages.status = 'pending' and bulk_mail_messages.send_date <= sysdate + for update