Index: openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/Attic/sweep-procs-oracle.xql,v diff -u -r1.12 -r1.13 --- openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql 4 Jul 2003 20:40:26 -0000 1.12 +++ openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql 4 Jul 2003 21:18:32 -0000 1.13 @@ -34,8 +34,7 @@ notification_requests.delivery_method_id, notification_requests.request_id, notifications.response_id, - notifications.notif_date, - notifications.notif_user + notifications.notif_date from notifications, notification_requests where notifications.type_id = notification_requests.type_id and notifications.object_id = notification_requests.object_id Index: openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/Attic/sweep-procs-postgresql.xql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql 4 Jul 2003 20:40:26 -0000 1.5 +++ openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql 4 Jul 2003 21:18:32 -0000 1.6 @@ -26,8 +26,7 @@ type_id, delivery_method_id, response_id, - notif_date, - notif_user + notif_date from notifications inner join notification_requests using (type_id, object_id) inner join acs_objects on (notification_requests.request_id = acs_objects.object_id) left outer join notification_user_map using (notification_id, user_id)