Index: openacs-4/packages/dotlrn/www/admin/terms.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/terms.adp,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/dotlrn/www/admin/terms.adp	8 Mar 2002 00:27:05 -0000	1.6
+++ openacs-4/packages/dotlrn/www/admin/terms.adp	11 Mar 2002 21:46:29 -0000	1.7
@@ -12,12 +12,14 @@
     <th align="left" width="15%">Term</th>
     <th align="left" width="15%">Start Date</th>
     <th align="left" width="15%">End Date</th>
+    <th align="left" width="15%">Number of Classes</th>
   </tr>
 <multiple name="terms">
   <tr>
     <td><a href="term?term_id=@terms.term_id@">@terms.term_name@ @terms.term_year@</a></td>
     <td>@terms.start_date@</td>
     <td>@terms.end_date@</td>
+    <td>@terms.n_classes@</td>
   </tr>
 </multiple>
 </table>
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>