Index: openacs-4/packages/dotlrn/www/admin/terms.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/terms.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/dotlrn/www/admin/terms.xql	7 Mar 2002 20:58:40 -0000	1.2
+++ openacs-4/packages/dotlrn/www/admin/terms.xql	11 Mar 2002 21:46:29 -0000	1.3
@@ -3,13 +3,16 @@
 <queryset>
   <fullquery name="select_terms">
     <querytext>
-      select term_id,
-             term_name,
-             term_year,
-             to_char(start_date, 'Mon DD YYYY') as start_date,
-             to_char(end_date, 'Mon DD YYYY') as end_date
+      select dotlrn_terms.term_id,
+             dotlrn_terms.term_name,
+             dotlrn_terms.term_year,
+             to_char(dotlrn_terms.start_date, 'Mon DD YYYY') as start_date,
+             to_char(dotlrn_terms.end_date, 'Mon DD YYYY') as end_date,
+             (select count(*)
+              from dotlrn_class_instances
+              where dotlrn_class_instances.term_id = dotlrn_terms.term_id) as n_classes
       from dotlrn_terms
-      order by start_date
+      order by dotlrn_terms.start_date
     </querytext>
   </fullquery>
 </queryset>