Index: openacs.org-dev/packages/acs-subsite/www/admin/site-map/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/acs-subsite/www/admin/site-map/index-oracle.xql,v
diff -u -N -r1.1.1.1 -r1.1.1.2
--- openacs.org-dev/packages/acs-subsite/www/admin/site-map/index-oracle.xql	9 Jul 2002 17:34:59 -0000	1.1.1.1
+++ openacs.org-dev/packages/acs-subsite/www/admin/site-map/index-oracle.xql	5 Aug 2002 21:38:24 -0000	1.1.1.2
@@ -55,6 +55,7 @@
             start with node_id = nvl(:root_id, site_node.node_id('/'))
             connect by prior node_id = parent_id and parent_id in ([join $expand ", "])) site_map
             where site_map.object_id = p.package_id (+)
+            order by url
         </querytext>
     </fullquery>
 
@@ -83,6 +84,7 @@
                     acs_permission.permission_p(package_id, :user_id, 'read') = 't'
                  or acs_permission.permission_p(package_id, acs.magic_object_id('the_public'), 'read') = 't'
                 )
+            order by instance_name
         </querytext>
     </fullquery>