Index: openacs-4/packages/edit-this-page/www/etp-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/edit-this-page/www/etp-postgresql.xql	24 Sep 2001 17:24:13 -0000	1.1
+++ openacs-4/packages/edit-this-page/www/etp-postgresql.xql	31 Oct 2001 05:00:08 -0000	1.2
@@ -15,5 +15,17 @@
 	   and r.revision_id = :revision_id
 </querytext>
 </fullquery>
+
+<fullquery name="get_content_pages">
+<querytext>
+  select name, title, tree_sortkey 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
+</querytext>
+</fullquery>
  
 </queryset>