Index: openacs-4/packages/general-comments/tcl/general-comments-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/general-comments/tcl/general-comments-procs-oracle.xql,v
diff -u -N -r1.4.4.1 -r1.4.4.2
--- openacs-4/packages/general-comments/tcl/general-comments-procs-oracle.xql	22 Mar 2004 02:54:57 -0000	1.4.4.1
+++ openacs-4/packages/general-comments/tcl/general-comments-procs-oracle.xql	29 Nov 2004 20:04:17 -0000	1.4.4.2
@@ -21,7 +21,8 @@
                     r.revision_id = content_item.get_live_revision(g.comment_id) and
                     o.object_id = g.comment_id
                     $context_clause
-              order by o.creation_date
+                    $my_comments_clause
+              order by $orderby
       </querytext>
 </fullquery>