Index: openacs-4/contrib/packages/project-manager/www/add-edit-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/add-edit-oracle.xql,v diff -u -N --- openacs-4/contrib/packages/project-manager/www/add-edit-oracle.xql 13 Jan 2005 13:54:36 -0000 1.2 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,41 +0,0 @@ - - - - - SELECT p.item_id as project_item_id, - p.parent_id, - p.project_id, - p.title as project_name, - p.project_code, - p.goal, - p.description, - p.customer_id, - p.status_id, - p.logger_project, - to_char(p.planned_start_date,'YYYY-MM-DD') as planned_start_date, - to_char(p.planned_end_date,'YYYY-MM-DD') as planned_end_date, - p.ongoing_p - FROM pm_projectsx p - WHERE p.item_id = :project_item_id and - p.project_id = :project_id - - - - - - SELECT sysdate - from dual - - - - - - SELECT description, - status_id - FROM pm_project_status - ORDER BY status_type desc, - description asc - - - -