Index: openacs-4/packages/edit-this-page/tcl/etp-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/tcl/etp-procs-oracle.xql,v
diff -u -N -r1.7 -r1.8
--- openacs-4/packages/edit-this-page/tcl/etp-procs-oracle.xql	10 Dec 2001 18:06:28 -0000	1.7
+++ openacs-4/packages/edit-this-page/tcl/etp-procs-oracle.xql	10 Dec 2001 19:02:02 -0000	1.8
@@ -118,7 +118,7 @@
            and i.live_revision = r.revision_id(+)
      ) attributes
      where $extra_where_clauses
-     order by item_id)
+     order by $orderby)
    $limit_clause
 </querytext>
 </fullquery>
Index: openacs-4/packages/edit-this-page/tcl/etp-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/tcl/etp-procs-postgresql.xql,v
diff -u -N -r1.8 -r1.9
--- openacs-4/packages/edit-this-page/tcl/etp-procs-postgresql.xql	10 Dec 2001 18:06:28 -0000	1.8
+++ openacs-4/packages/edit-this-page/tcl/etp-procs-postgresql.xql	10 Dec 2001 19:02:02 -0000	1.9
@@ -111,10 +111,12 @@
 
 <fullquery name="etp::get_content_items.get_content_items">
 <querytext>
-   select $columns
-   from cr_items i left join cr_revisions r on (i.live_revision = r.revision_id)
-   where i.parent_id = etp__get_folder_id(:package_id) and i.name != 'index'
-     and $extra_where_clauses
+   select * from
+     (select $columns
+      from cr_items i left join cr_revisions r on (i.live_revision = r.revision_id)
+      where i.parent_id = etp__get_folder_id(:package_id) and i.name != 'index'
+     ) attributes
+   where $extra_where_clauses
    order by $orderby
    $limit_clause
 </querytext>