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 -r1.4 -r1.5
--- openacs-4/packages/edit-this-page/tcl/etp-procs-oracle.xql	17 Nov 2001 19:48:47 -0000	1.4
+++ openacs-4/packages/edit-this-page/tcl/etp-procs-oracle.xql	19 Nov 2001 05:35:59 -0000	1.5
@@ -117,11 +117,12 @@
            and i.live_revision = r.revision_id(+)
      ) attributes
      where $extra_where_clauses
-     order by $orderby
+     order by item_id
      $limit_clause
 </querytext>
 </fullquery>
 
+
 <fullquery name="etp::get_subtopics.get_subtopics">
 <querytext>
 select child.name, child.node_id, child.object_id as package_id,
@@ -135,4 +136,23 @@
 </querytext>
 </fullquery>
  
+
+   <partialquery name="etp::get_attribute_lookup_sql.archive_where_clause">
+      <querytext>
+        etp.get_attribute_value(r.revision_id, $attribute_id)
+      </querytext>
+   </partialquery>
+
+   <partialquery name="etp::get_content_items.gci_columns_clause">
+      <querytext>
+       i.item_id, i.name,
+                 to_char(r.publish_date, 'Mon DD, YYYY') as publish_date,
+                 (select object_type from acs_objects 
+                   where object_id = i.item_id) as object_type,
+                 etp.get_relative_url(i.item_id, i.name) as url,
+                 etp.get_title(i.item_id, r.title) as title,
+                 etp.get_description(i.item_id, r.description) as description
+      </querytext>
+   </partialquery>
+
 </queryset>