Index: openacs-4/packages/wp-slim/www/edit-slide-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/wp-slim/www/Attic/edit-slide-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/wp-slim/www/edit-slide-postgresql.xql	4 Oct 2001 04:23:13 -0000	1.1
+++ openacs-4/packages/wp-slim/www/edit-slide-postgresql.xql	15 Nov 2001 01:47:13 -0000	1.2
@@ -8,51 +8,15 @@
       
 select s.slide_title,
        s.sort_key,
-       s.original_slide_id
+       s.original_slide_id,
+       wp_slide__get_preamble(:slide_item_id) as preamble,
+       wp_slide__get_postamble(:slide_item_id) as postamble,
+       wp_slide__get_bullet_items(:slide_item_id) as bullet_items
 from cr_wp_slides s, cr_items i
 where i.item_id = :slide_item_id
 and   i.live_revision = s.slide_id
 
       </querytext>
 </fullquery>
-
-<fullquery name="get_pre_info">
-      <querytext>
-  select content as preamble
-  from cr_revisions, cr_items
-  where cr_items.content_type = 'cr_wp_slide_preamble'
-  and cr_items.parent_id = :slide_item_id
-  and cr_revisions.revision_id = cr_items.live_revision
-
-
-      </querytext>
-</fullquery>
-
-
-<fullquery name="get_pos_info">
-      <querytext>
-select content as postamble
-  from cr_revisions, cr_items
-  where cr_items.content_type = 'cr_wp_slide_postamble'
-  and cr_items.parent_id = :slide_item_id
-  and cr_revisions.revision_id = cr_items.live_revision
-
-
-
-      </querytext>
-</fullquery>
-
-
-<fullquery name="get_bul_info">
-      <querytext>
-
-  select content as bullet_items
-  from cr_revisions, cr_items
-  where cr_items.content_type = 'cr_wp_slide_bullet_items'
-  and cr_items.parent_id = :slide_item_id
-  and cr_revisions.revision_id = cr_items.live_revision;
-
-      </querytext>
-</fullquery>
  
 </queryset>