Index: openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql 3 Jun 2002 22:27:00 -0000 1.3 +++ openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql 25 Jun 2002 16:27:03 -0000 1.4 @@ -13,7 +13,7 @@ notification_user_map where notifications.type_id = notification_requests.type_id and notifications.object_id = notification_requests.object_id - and notifications.notification_id = notification_user_map.notification_id (+) + and notifications.notification_id = notification_user_map.notification_id(+) and sent_date is null) @@ -32,7 +32,7 @@ where notifications.type_id = notification_requests.type_id and interval_id = :interval_id and notifications.object_id = notification_requests.object_id - and notifications.notification_id = notification_user_map.notification_id (+) + and notifications.notification_id = notification_user_map.notification_id(+) and sent_date is null