Index: openacs-4/packages/calendar/tcl/cal-item-2-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/Attic/cal-item-2-procs-oracle.xql,v diff -u -N -r1.4 -r1.5 --- openacs-4/packages/calendar/tcl/cal-item-2-procs-oracle.xql 22 Jul 2002 21:46:19 -0000 1.4 +++ openacs-4/packages/calendar/tcl/cal-item-2-procs-oracle.xql 13 Aug 2002 22:06:38 -0000 1.5 @@ -3,6 +3,18 @@ oracle8.1.6 + + + + select CASE WHEN (to_date(:start_date,:date_format) - to_date(:end_date,:date_format)) < 0 + THEN 1 + ELSE -1 + END + from dual + + + +