Index: openacs-4/packages/edit-this-page/www/etp-delete-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-delete-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/edit-this-page/www/etp-delete-oracle.xql 24 Sep 2001 17:24:13 -0000 1.1
+++ openacs-4/packages/edit-this-page/www/etp-delete-oracle.xql 31 Oct 2001 04:24:17 -0000 1.2
@@ -9,5 +9,25 @@
end;
-
+
+
+
+ select title
+ from cr_revisions r, cr_items i
+ where i.parent_id = etp.get_folder_id(:package_id)
+ and i.name = :name
+ and r.item_id = i.item_id
+ and r.revision_id = i.live_revision
+
+
+
+
+
+ select item_id
+ from cr_items
+ where parent_id = etp.get_folder_id(:package_id)
+ and name = :name
+
+
+
Index: openacs-4/packages/edit-this-page/www/etp-delete-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-delete-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/edit-this-page/www/etp-delete-postgresql.xql 24 Sep 2001 17:24:13 -0000 1.1
+++ openacs-4/packages/edit-this-page/www/etp-delete-postgresql.xql 31 Oct 2001 04:24:09 -0000 1.2
@@ -8,4 +8,24 @@
+
+
+ select title
+ from cr_revisions r, cr_items i
+ where i.parent_id = etp__get_folder_id(:package_id)
+ and i.name = :name
+ and r.item_id = i.item_id
+ and r.revision_id = i.live_revision
+
+
+
+
+
+ select item_id
+ from cr_items
+ where parent_id = etp__get_folder_id(:package_id)
+ and name = :name
+
+
+
Index: openacs-4/packages/edit-this-page/www/etp-delete.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-delete.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/edit-this-page/www/etp-delete.xql 24 Sep 2001 17:24:13 -0000 1.1
+++ openacs-4/packages/edit-this-page/www/etp-delete.xql 31 Oct 2001 04:24:09 -0000 1.2
@@ -1,26 +1,6 @@
-
-
- select title
- from cr_revisions r, cr_items i
- where i.parent_id = etp_get_folder_id(:package_id)
- and i.name = :name
- and r.item_id = i.item_id
- and r.revision_id = i.live_revision
-
-
-
-
-
- select item_id
- from cr_items
- where parent_id = etp_get_folder_id(:package_id)
- and name = :name
-
-
-
update cr_items set live_revision=null, latest_revision=null