Index: openacs-4/contrib/packages/project-manager/tcl/project-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/tcl/Attic/project-procs-postgresql.xql,v
diff -u -r1.2.2.3 -r1.2.2.4
--- openacs-4/contrib/packages/project-manager/tcl/project-procs-postgresql.xql	27 Feb 2004 22:46:13 -0000	1.2.2.3
+++ openacs-4/contrib/packages/project-manager/tcl/project-procs-postgresql.xql	6 Mar 2004 00:29:24 -0000	1.2.2.4
@@ -57,6 +57,7 @@
                 to_timestamp(:planned_end_date,'YYYY MM DD HH24 MI SS'),
                 null,
                 null,
+                :logger_project,
                 :ongoing_p,
                 :status_id,
                 :organization_id,
@@ -95,8 +96,9 @@
 
   <fullquery name="pm::project::compute_status.tasks_query">
     <querytext>
-        select
-        t.actual_hours_worked as worked,
+        SELECT
+        case when t.actual_hours_worked is null then 0 
+                else t.actual_hours_worked end as worked,
         t.estimated_hours_work as to_work,
         t.item_id as my_iid,
         to_char(end_date,'J') as task_deadline_j