Index: openacs-4/packages/calendar/www/view-one-day-display-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/view-one-day-display-postgresql.xql,v diff -u -r1.8 -r1.9 --- openacs-4/packages/calendar/www/view-one-day-display-postgresql.xql 17 Aug 2003 18:08:16 -0000 1.8 +++ openacs-4/packages/calendar/www/view-one-day-display-postgresql.xql 9 Sep 2003 09:11:14 -0000 1.9 @@ -26,10 +26,9 @@ and ci.cal_item_id= e.event_id and to_char(start_date, 'HH24:MI') = '00:00' and to_char(end_date, 'HH24:MI') = '00:00' -and cals.package_id= :package_id -and (cals.private_p='f' or (cals.private_p='t' and cals.owner_id= :user_id)) and cals.calendar_id = ci.on_which_calendar and e.event_id = ci.cal_item_id +$calendars_clause @@ -58,10 +57,11 @@ and ci.cal_item_id= e.event_id and (to_char(start_date, 'HH24:MI') <> '00:00' or to_char(end_date, 'HH24:MI') <> '00:00') -and cals.package_id= :package_id -and (cals.private_p='f' or (cals.private_p='t' and cals.owner_id= :user_id)) and cals.calendar_id = ci.on_which_calendar and e.event_id = ci.cal_item_id +$calendars_clause +$start_clause +$end_clause order by to_char(start_date,'HH24')