Index: openacs-4/contrib/obsolete-packages/bboard/www/simple-message-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard/www/simple-message-oracle.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/obsolete-packages/bboard/www/simple-message-oracle.xql	28 Aug 2003 09:41:48 -0000	1.3
@@ -0,0 +1,20 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="get_attachments">      
+      <querytext>
+      
+	select object_id as file_id, cr.title, ci.name
+            from acs_objects ao, cr_items ci, cr_revisions cr
+            where object_id = ci.item_id and
+                  live_revision = revision_id and
+	          object_type = 'content_item' and
+                  context_id = :id
+    
+      </querytext>
+</fullquery>
+
+ 
+</queryset>