Index: openacs-4/packages/acs-admin/www/users/registration-history.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/registration-history.tcl,v diff -u -r1.2 -r1.2.26.1 --- openacs-4/packages/acs-admin/www/users/registration-history.tcl 6 Sep 2002 21:49:53 -0000 1.2 +++ openacs-4/packages/acs-admin/www/users/registration-history.tcl 10 Sep 2014 06:54:41 -0000 1.2.26.1 @@ -14,11 +14,16 @@ # we have to query for pretty month and year separately because Oracle pads # month with spaces that we need to trim -db_multirow user_rows user_rows "select to_char(creation_date,'YYYYMM') as sort_key, rtrim(to_char(creation_date,'Month')) as pretty_month, to_char(creation_date,'YYYY') as pretty_year, count(*) as n_new -from users, acs_objects -where users.user_id = acs_objects.object_id -and creation_date is not null -group by to_char(creation_date,'YYYYMM'), to_char(creation_date,'Month'), to_char(creation_date,'YYYY') -order by 1" +db_multirow user_rows user_rows { + select to_char(creation_date,'YYYYMM') as sort_key, + rtrim(to_char(creation_date,'Month')) as pretty_month, + to_char(creation_date,'YYYY') as pretty_year, + count(*) as n_new + from users, acs_objects + where users.user_id = acs_objects.object_id + and creation_date is not null + group by to_char(creation_date,'YYYYMM'), to_char(creation_date,'Month'), to_char(creation_date,'YYYY') + order by 1 +} ad_return_template