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.3 -r1.9.2.4
--- openacs-4/contrib/packages/project-manager/www/add-edit-postgresql.xql	9 Feb 2004 16:27:59 -0000	1.9.2.3
+++ openacs-4/contrib/packages/project-manager/www/add-edit-postgresql.xql	27 Feb 2004 22:46:13 -0000	1.9.2.4
@@ -2,32 +2,31 @@
 <queryset>
   <fullquery name="project_query">
     <querytext>
-         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
+        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,
+ 	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>
 
   <fullquery name="do_nothing">
     <querytext>
         SELECT
         current_timestamp
-        FROM
-	pm_projects
     </querytext>
   </fullquery>
 
@@ -45,6 +44,7 @@
 		null,
 		:ongoing_p,
                 :status_id,
+                :customer_id,
 		now(),
 		:user_id,
 		:peeraddr,
@@ -77,17 +77,6 @@
     </querytext>
   </fullquery>
 
-  <fullquery name="get_item_id">
-    <querytext>
-	SELECT
-        p.item_id as project_item_id
-	FROM
-	pm_projectsx p
-	WHERE
-	p.project_id = :project_id
-    </querytext>
-  </fullquery>
-
   <fullquery name="get_status_codes">
     <querytext>
 	SELECT