Index: openacs-4/packages/categories/tcl/categories-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/categories/tcl/categories-procs.tcl,v diff -u -N -r1.38.2.10 -r1.38.2.11 --- openacs-4/packages/categories/tcl/categories-procs.tcl 9 Oct 2020 15:47:52 -0000 1.38.2.10 +++ openacs-4/packages/categories/tcl/categories-procs.tcl 9 Oct 2020 15:50:08 -0000 1.38.2.11 @@ -294,13 +294,13 @@ category_translations ct, acs_objects ao, acs_objects aot - where co.object_id = :object_id - and co.category_id = c.category_id - and c.category_id = ao.object_id - and c.category_id = ct.category_id - and aot.object_id = co.tree_id - and ct.locale = :locale - order by aot.title, ao.title + where co.object_id = :object_id + and co.category_id = c.category_id + and c.category_id = ao.object_id + and c.category_id = ct.category_id + and aot.object_id = co.tree_id + and ct.locale = :locale + order by aot.title, ao.title } } @@ -454,11 +454,11 @@ @author Peter Kreuzinger (peter.kreuzinger@wu-wien.ac.at) } { return [db_list get_children_ids { - select category_id - from categories - where parent_id = :category_id - and deprecated_p = 'f' - order by tree_id, left_ind + select category_id + from categories + where parent_id = :category_id + and deprecated_p = 'f' + order by tree_id, left_ind }] }