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