Index: openacs-4/contrib/packages/project-manager/www/task-edit-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-edit-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/contrib/packages/project-manager/www/task-edit-postgresql.xql 21 Aug 2003 22:34:43 -0000 1.3 +++ openacs-4/contrib/packages/project-manager/www/task-edit-postgresql.xql 4 Sep 2003 22:45:23 -0000 1.4 @@ -7,8 +7,9 @@ :project_item_id, :task_title, :description, - to_timestamp(:end_date,'YYYY MM DD HH24 MI SS'), + [project_manager::project::util::datenvl -value $end_date -value_if_null "null," -value_if_not_null "to_timestamp('$end_date','YYYY MM DD HH24 MI SS'),"] :percent_complete, + :estimated_hours_work, :estimated_hours_work_min, :estimated_hours_work_max, :actual_hours_worked, @@ -44,6 +45,7 @@ t.parent_id, to_char(t.end_date,'YYYY MM DD') as end_date, t.percent_complete, + t.estimated_hours_work, t.estimated_hours_work_min, t.estimated_hours_work_max, t.actual_hours_worked