Index: openacs-4/packages/dotlrn-wps/www/wps-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-wps/www/Attic/wps-portlet-oracle.xql,v
diff -u -N
--- openacs-4/packages/dotlrn-wps/www/wps-portlet-oracle.xql	25 Sep 2003 16:35:43 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,22 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
-
-    <fullquery name="select_presentations">
-        <querytext>
-		select o.context_id as package_id, i.item_id as pres_item_id,
-			acs_object.name(apm_package.parent_id(o.context_id)) as parent_name,
-			p.pres_title,  (select site_node.url(site_nodes.node_id)  from site_nodes  where site_nodes.object_id = o.context_id) as url
-	                from cr_items i, cr_wp_presentations p     , acs_objects o
-			where o.context_id in  ( [join $list_of_package_ids ", "] )
-			and  p.presentation_id = i.live_revision
-			and i.item_id = o.object_id
-			and   p.public_p = 't'
-                    order by i.item_id desc, pres_title
-
-        </querytext>
-    </fullquery>
-
-</queryset>
-