Index: openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql	14 Sep 2002 20:20:47 -0000	1.11
+++ openacs-4/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql	17 May 2003 10:04:18 -0000	1.12
@@ -14,6 +14,7 @@
             select site_node.url(site_nodes.node_id) as url,
                    site_nodes.node_id,
                    site_nodes.parent_id,
+                   site_nodes.name,
                    site_nodes.directory_p,
                    site_nodes.pattern_p,
                    site_nodes.object_id,
@@ -34,6 +35,7 @@
             select site_node.url(site_nodes.node_id) as url,
                    site_nodes.node_id,
                    site_nodes.parent_id,
+                   site_nodes.name,
                    site_nodes.directory_p,
                    site_nodes.pattern_p,
                    site_nodes.object_id,
@@ -55,6 +57,7 @@
             select site_node.url(node_id)
             from site_nodes
             where object_id = :object_id
+            order by site_node.url(node_id) desc
         </querytext>
     </fullquery>