Index: openacs-4/packages/calendar/www/views-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/views-oracle.xql,v
diff -u -r1.5.6.2 -r1.5.6.3
--- openacs-4/packages/calendar/www/views-oracle.xql	12 Mar 2007 01:32:06 -0000	1.5.6.2
+++ openacs-4/packages/calendar/www/views-oracle.xql	17 May 2007 13:14:58 -0000	1.5.6.3
@@ -20,7 +20,8 @@
          e.event_id as item_id,
          (select type from cal_item_types where item_type_id= ci.item_type_id) as item_type,
 	 cals.calendar_id,
-	 cals.calendar_name
+	 cals.calendar_name,
+         (select count(1) from attachments where object_id=e.event_id) as num_attachments
          $additional_select_clause
     from cal_items ci,
          acs_events e,
@@ -55,7 +56,8 @@
          e.event_id as item_id,
          (select type from cal_item_types where item_type_id= ci.item_type_id) as item_type,
 	 cals.calendar_id,
-	 cals.calendar_name
+	 cals.calendar_name,
+         (select count(1) from attachments where object_id=e.event_id) as num_attachments
          $additional_select_clause
     from cal_items ci,
          acs_events e,