Index: openacs-4/packages/wp-slim/www/serve-slide-revision-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/wp-slim/www/serve-slide-revision-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/wp-slim/www/serve-slide-revision-postgresql.xql	4 Oct 2001 04:23:13 -0000	1.1
+++ openacs-4/packages/wp-slim/www/serve-slide-revision-postgresql.xql	15 Nov 2001 01:47:13 -0000	1.2
@@ -22,5 +22,15 @@
       </querytext>
 </fullquery>
 
+<fullquery name="get_attachments">      
+      <querytext>
+          select live_revision as attach_id, display, name as file_name
+          from (select live_revision, name
+                from cr_items
+                where parent_id = :slide_item_id and
+                   content_type in ('cr_wp_image_attachment', 'cr_wp_file_attachment')) a
+              left join cr_wp_image_attachments on (a.live_revision = attach_id)
+      </querytext>
+</fullquery>
  
 </queryset>