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.8 -r1.9
--- openacs-4/contrib/packages/project-manager/www/add-edit-postgresql.xql	4 Sep 2003 22:45:23 -0000	1.8
+++ openacs-4/contrib/packages/project-manager/www/add-edit-postgresql.xql	18 Sep 2003 23:33:54 -0000	1.9
@@ -46,20 +46,22 @@
 
   <fullquery name="project_query">
     <querytext>
-      select
-        item_id as project_item_id,
-        parent_id,
-	project_id,
-        title as project_name,
-        project_code,
-	goal,
-	description,
-	to_char(planned_start_date,'YYYY MM DD') as planned_start_date,
-	to_char(planned_end_date,'YYYY MM DD') as planned_end_date,
-	ongoing_p
-	FROM
-	pm_projectsx
-       where 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,
+	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>