Index: openacs-4/packages/calendar/www/cal-weekview-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/cal-weekview-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/calendar/www/cal-weekview-postgresql.xql 24 Aug 2001 01:47:36 -0000 1.1 +++ openacs-4/packages/calendar/www/cal-weekview-postgresql.xql 7 Sep 2001 02:49:18 -0000 1.2 @@ -8,9 +8,9 @@ select to_char(to_date(:current_date, 'yyyy-mm-dd'), 'D') as day_of_the_week, - to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'SUNDAY')) + to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'SUNDAY'),'DAY') as sunday_of_the_week, - to_char(next_day(to_date(:current_date, 'yyyy-mm-dd'), 'Saturday')) + to_char(next_day(to_date(:current_date, 'yyyy-mm-dd'), 'Saturday'),'DAY') as saturday_of_the_week from dual Index: openacs-4/packages/calendar/www/cal-weekview.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/cal-weekview.tcl,v diff -u -r1.2 -r1.3 --- openacs-4/packages/calendar/www/cal-weekview.tcl 6 Sep 2001 06:30:43 -0000 1.2 +++ openacs-4/packages/calendar/www/cal-weekview.tcl 7 Sep 2001 02:49:18 -0000 1.3 @@ -176,11 +176,11 @@ while {$i < $num_hour_rows} { set sql " - select to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'SUNDAY')+:i, 'DAY') + select to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'SUNDAY')+$i, 'DAY') as weekday, - to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'SUNDAY')+:i, 'YYYY-MM-DD') + to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'SUNDAY')+$i, 'YYYY-MM-DD') as pretty_date, - to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'SUNDAY')+:i, 'J') + to_char(next_day(to_date(:current_date, 'yyyy-mm-dd')-7, 'SUNDAY')+$i, 'J') as start_date from dual "