Index: openacs-4/packages/project-manager/www/task-select-project-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/www/task-select-project-oracle.xql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/project-manager/www/task-select-project-oracle.xql	29 Apr 2005 17:43:38 -0000	1.1
+++ openacs-4/packages/project-manager/www/task-select-project-oracle.xql	30 Nov 2005 06:47:37 -0000	1.1.2.1
@@ -1,24 +1,7 @@
 <?xml version="1.0"?>
 <queryset>
 
-  <fullquery name="select_a_project">
-    <querytext>
-        SELECT  p.item_id as project_item_id,
-                p.title as project_name,
-                p.description as description,
-                p.mime_type,
-                o.organization_id as customer_id,
-                o.name as customer_name
-        FROM pm_projectsx p LEFT JOIN organizations o on p.customer_id = o.organization_id,
-             cr_items i, 
-             pm_project_status s
-        WHERE p.project_id = i.live_revision and
-              p.parent_id = :root_folder and
-              p.status_id = s.status_id 
-             [template::list::filter_where_clauses -and -name projects]
-             [template::list::orderby_clause -orderby -name projects]
-    </querytext>
-  </fullquery>
+<rdbms><type>oracle</type><version>9.2</version></rdbms>
 
   <fullquery name="get_root">
     <querytext>