Index: openacs-4/packages/calendar/www/cal-dayview-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/cal-dayview-oracle.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/calendar/www/cal-dayview-oracle.xql 23 Sep 2001 14:45:00 -0000 1.1 +++ openacs-4/packages/calendar/www/cal-dayview-oracle.xql 16 Oct 2001 18:18:36 -0000 1.2 @@ -9,7 +9,7 @@ select to_char(start_date, 'HH24') as start_hour, to_char(start_date, 'HH24:MI') as pretty_start_date, to_char(end_date, 'HH24:MI') as pretty_end_date, - coalesce(e.name, a.name) as name, + nvl(e.name, a.name) as name, e.event_id as item_id from acs_activities a, acs_events e, @@ -38,7 +38,7 @@ select to_char(start_date, 'HH24') as start_hour, to_char(start_date, 'HH24:MI') as pretty_start_date, to_char(end_date, 'HH24:MI') as pretty_end_date, - coalesce(e.name, a.name) as name, + nvl(e.name, a.name) as name, e.event_id as item_id from acs_activities a, acs_events e,