Index: openacs-4/packages/edit-this-page/www/etp-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/edit-this-page/www/etp-oracle.xql	17 Nov 2001 19:48:47 -0000	1.3
+++ openacs-4/packages/edit-this-page/www/etp-oracle.xql	20 Nov 2001 02:04:50 -0000	1.4
@@ -9,7 +9,7 @@
                content_revision.get_number(i.live_revision) as live_revision,
 	       r.description, r.publish_date, r.content $extended_attributes
 	  from cr_items i, cr_revisions r
-	 where i.parent_id = :package_id
+	 where i.parent_id = etp.get_folder_id(:package_id)
 	   and i.name = :name
 	   and i.item_id = r.item_id
 	   and r.revision_id = :revision_id
@@ -18,13 +18,13 @@
 
 <fullquery name="get_content_pages">
 <querytext>
-  select name, title, tree_sortkey as sort_order
+  select name, title, rownum as sort_order
     from cr_items i, cr_revisions r
    where i.parent_id = etp.get_folder_id(:package_id)
      and i.name != 'index'
      and i.item_id = r.item_id
      and i.latest_revision = r.revision_id
-   order by tree_sortkey
+   order by sort_order
 </querytext>
 </fullquery>