Index: openacs-4/packages/edit-this-page/www/etp-edit-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-edit-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/edit-this-page/www/etp-edit-oracle.xql	31 Oct 2001 04:29:03 -0000	1.1
@@ -0,0 +1,28 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="get_standard_attribute">
+<querytext>
+        select $attribute as value, r.title as page_title
+          from cr_revisions r, cr_items i
+         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
+</querytext>
+</fullquery>
+
+<fullquery name="get_extended_attribute">
+<querytext>
+	select etp_get_attribute_value(r.revision_id, :attribute_id) as value,
+	       r.title as page_title
+	  from cr_items i, cr_revisions r
+	 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
+</querytext>
+</fullquery>
+ 
+</queryset>
Index: openacs-4/packages/edit-this-page/www/etp-edit-postgres.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/Attic/etp-edit-postgres.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/edit-this-page/www/etp-edit-postgres.xql	31 Oct 2001 04:29:08 -0000	1.1
@@ -0,0 +1,28 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="get_standard_attribute">
+<querytext>
+        select $attribute as value, r.title as page_title
+          from cr_revisions r, cr_items i
+         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
+</querytext>
+</fullquery>
+
+<fullquery name="get_extended_attribute">
+<querytext>
+	select etp_get_attribute_value(r.revision_id, :attribute_id) as value,
+	       r.title as page_title
+	  from cr_items i, cr_revisions r
+	 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
+</querytext>
+</fullquery>
+ 
+</queryset>