Index: openacs-4/packages/forums/www/forum-view-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/forum-view-oracle.xql,v
diff -u -r1.9 -r1.9.2.1
--- openacs-4/packages/forums/www/forum-view-oracle.xql	3 Oct 2003 18:26:31 -0000	1.9
+++ openacs-4/packages/forums/www/forum-view-oracle.xql	1 Dec 2003 10:36:27 -0000	1.9.2.1
@@ -44,4 +44,15 @@
         </querytext>
     </fullquery>
 
+    <partialquery name="orderby_user_name_desc">
+        <querytext>
+	user_name desc
+        </querytext>
+    </partialquery>
+    <partialquery name="orderby_user_name_asc">
+        <querytext>
+	user_name asc
+        </querytext>
+    </partialquery>
+
 </queryset>
Index: openacs-4/packages/forums/www/forum-view-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/forum-view-postgresql.xql,v
diff -u -r1.11 -r1.11.2.1
--- openacs-4/packages/forums/www/forum-view-postgresql.xql	3 Oct 2003 18:26:31 -0000	1.11
+++ openacs-4/packages/forums/www/forum-view-postgresql.xql	1 Dec 2003 10:36:27 -0000	1.11.2.1
@@ -43,5 +43,15 @@
             [template::list::orderby_clause -orderby -name "messages"]
         </querytext>
     </fullquery>
+    <partialquery name="orderby_user_name_desc">
+        <querytext>
+	lower(person__name(fm.user_id)) desc
+        </querytext>
+    </partialquery>
+    <partialquery name="orderby_user_name_asc">
+        <querytext>
+	lower(person__name(fm.user_id)) asc
+        </querytext>
+    </partialquery>
 
 </queryset>