Index: openacs-4/contrib/packages/project-manager/www/add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/add-edit-postgresql.xql,v
diff -u -r1.9.2.2 -r1.9.2.3
--- openacs-4/contrib/packages/project-manager/www/add-edit-postgresql.xql	4 Feb 2004 20:17:19 -0000	1.9.2.2
+++ openacs-4/contrib/packages/project-manager/www/add-edit-postgresql.xql	9 Feb 2004 16:27:59 -0000	1.9.2.3
@@ -2,7 +2,23 @@
 <queryset>
   <fullquery name="project_query">
     <querytext>
-        select p.end_date from pm_tasks_revisions p
+         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.status_id, 	 
+         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
     </querytext>
   </fullquery>
 
@@ -52,6 +68,7 @@
 		null,
 		:ongoing_p,
                 :status_id,
+                :customer_id,
 		now(),
 		:user_id,
 		:peeraddr,