Index: openacs-4/contrib/packages/classified-ads/tcl/categories-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/classified-ads/tcl/categories-procs-postgresql.xql,v diff -u -N -r1.4 -r1.4.2.1 --- openacs-4/contrib/packages/classified-ads/tcl/categories-procs-postgresql.xql 31 Jul 2003 09:31:00 -0000 1.4 +++ openacs-4/contrib/packages/classified-ads/tcl/categories-procs-postgresql.xql 1 Feb 2004 02:14:30 -0000 1.4.2.1 @@ -110,7 +110,10 @@ subtree.keyword_id from cr_keywords parent, cr_keywords subtree where parent.keyword_id = :keyword_id - and subtree.tree_sortkey between parent.tree_sortkey and tree_right(parent.tree_sortkey) + and parent.tree_sortkey between + subtree.tree_sortkey + and + tree_right(subtree.tree_sortkey) ) keywords WHERE att.attribute_id = ca.attribute_id @@ -133,7 +136,10 @@ subtree.keyword_id from cr_keywords parent, cr_keywords subtree where parent.keyword_id = :keyword_id - and subtree.tree_sortkey between parent.tree_sortkey and tree_right(parent.tree_sortkey) + and parent.tree_sortkey between + subtree.tree_sortkey + and + tree_right(subtree.tree_sortkey) ) keywords WHERE att.attribute_id = ca.attribute_id Index: openacs-4/contrib/packages/classified-ads/www/index.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/classified-ads/www/index.adp,v diff -u -N -r1.1.2.2 -r1.1.2.3 --- openacs-4/contrib/packages/classified-ads/www/index.adp 31 Jan 2004 11:12:21 -0000 1.1.2.2 +++ openacs-4/contrib/packages/classified-ads/www/index.adp 1 Feb 2004 02:14:30 -0000 1.1.2.3 @@ -6,8 +6,10 @@

-

Categories

+

Categories

+

+