Index: openacs-4/packages/acs-service-contract/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/Attic/index-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-service-contract/www/index-oracle.xql	17 May 2003 09:56:59 -0000	1.2
+++ openacs-4/packages/acs-service-contract/www/index-oracle.xql	9 Sep 2003 09:37:16 -0000	1.3
@@ -5,17 +5,19 @@
 
 <fullquery name="valid_installed_binding">      
       <querytext>
-        select 
-            b.contract_id,
-            b.impl_id,
-            acs_sc_contract.get_name(contract_id) as contract_name,
-            acs_sc_impl.get_name(b.impl_id) as impl_name,
-            impl.impl_owner_name
-        from
-            acs_sc_bindings b, 
-            acs_sc_impls impl
-        where
-            impl.impl_id = b.impl_id
+        select q.* 
+        from (select 
+                  b.contract_id,
+                  b.impl_id,
+                  acs_sc_contract.get_name(contract_id) as contract_name,
+                  acs_sc_impl.get_name(b.impl_id) as impl_name,
+                  impl.impl_owner_name
+              from
+                  acs_sc_bindings b, 
+                  acs_sc_impls impl
+              where
+                  impl.impl_id = b.impl_id) q
+        order  by upper(contract_name), contract_name, upper(impl_name), impl_name
       </querytext>
 </fullquery>
 
Index: openacs-4/packages/acs-service-contract/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/Attic/index-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-service-contract/www/index-postgresql.xql	17 May 2003 09:56:59 -0000	1.2
+++ openacs-4/packages/acs-service-contract/www/index-postgresql.xql	9 Sep 2003 09:37:16 -0000	1.3
@@ -5,17 +5,19 @@
 
 <fullquery name="valid_installed_binding">      
       <querytext>
-         select 
-            b.contract_id,
-            b.impl_id,
-            acs_sc_contract__get_name(contract_id) as contract_name,
-            acs_sc_impl__get_name(b.impl_id) as impl_name,
-            impl.impl_owner_name
-        from
-            acs_sc_bindings b, 
-            acs_sc_impls impl
-        where
-            impl.impl_id = b.impl_id
+        select q.* 
+        from (select 
+                  b.contract_id,
+                  b.impl_id,
+                  acs_sc_contract__get_name(contract_id) as contract_name,
+                  acs_sc_impl__get_name(b.impl_id) as impl_name,
+                  impl.impl_owner_name
+              from
+                  acs_sc_bindings b, 
+                  acs_sc_impls impl
+              where
+                  impl.impl_id = b.impl_id) q
+        order  by upper(contract_name), contract_name, upper(impl_name), impl_name
       </querytext>
 </fullquery>
  
Index: openacs-4/packages/acs-service-contract/www/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/index.tcl,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/acs-service-contract/www/index.tcl	16 Oct 2002 15:09:59 -0000	1.5
+++ openacs-4/packages/acs-service-contract/www/index.tcl	9 Sep 2003 09:37:16 -0000	1.6
@@ -1,6 +1,12 @@
 set context [list]
 
-db_multirow defined_contracts defined_contracts {select contract_id,contract_name,contract_desc from acs_sc_contracts}
+db_multirow defined_contracts defined_contracts {
+    select contract_id,
+           contract_name,
+           contract_desc 
+    from   acs_sc_contracts 
+    order  by upper(contract_name), contract_name
+}
 
 db_multirow valid_installed_binding valid_installed_binding ""
 
Index: openacs-4/packages/acs-service-contract/www/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/index.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-service-contract/www/index.xql	8 Mar 2002 20:23:12 -0000	1.2
+++ openacs-4/packages/acs-service-contract/www/index.xql	9 Sep 2003 09:37:16 -0000	1.3
@@ -5,21 +5,24 @@
 <fullquery name="valid_uninstalled_binding">      
    <querytext>
      select contract_id, contract_name, impl_name,impl_id 
-     from valid_uninstalled_bindings
+     from   valid_uninstalled_bindings
+     order  by upper(contract_name), contract_name, upper(impl_name), impl_name
    </querytext>
 </fullquery>
 
 <fullquery name="invalid_uninstalled_binding">      
    <querytext>
       select contract_id, contract_name, impl_name,impl_id 
-      from invalid_uninstalled_bindings
+      from   invalid_uninstalled_bindings
+      order  by upper(contract_name), contract_name, upper(impl_name), impl_name
    </querytext>
 </fullquery>
 
 <fullquery name="orphan_implementation">      
    <querytext>
       select impl_id, impl_name, impl_contract_name  
-      from orphan_implementations
+      from   orphan_implementations
+      order  by upper(impl_name), impl_name
    </querytext>
 </fullquery>