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.5 -r1.6 --- openacs-4/packages/dotlrn/www/admin/terms.xql 29 Mar 2002 19:38:26 -0000 1.5 +++ openacs-4/packages/dotlrn/www/admin/terms.xql 1 May 2002 01:19:47 -0000 1.6 @@ -1,18 +1,20 @@ - - - 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 dotlrn_terms.start_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 dotlrn_terms.start_date + + +