Index: openacs-4/packages/evaluation/www/admin/tasks/task-add-edit-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/tasks/task-add-edit-postgresql.xql,v diff -u -r1.9 -r1.10 --- openacs-4/packages/evaluation/www/admin/tasks/task-add-edit-postgresql.xql 10 Sep 2004 19:16:33 -0000 1.9 +++ openacs-4/packages/evaluation/www/admin/tasks/task-add-edit-postgresql.xql 4 Apr 2005 18:22:36 -0000 1.10 @@ -3,18 +3,6 @@ postgresql7.3 - - - - select grade_plural_name, - grade_name, - weight as grade_weight, - grade_item_id - from evaluation_grades where grade_id = :grade_id - - - - @@ -30,21 +18,10 @@ - - - - select et.task_name, et.description, to_char(et.due_date,'YYYY-MM-DD HH24:MI:SS') as due_date_ansi, - et.weight, et.number_of_members, et.online_p, et.late_submit_p, et.requires_grade_p - from evaluation_tasksi et - where task_id = :task_id - - - - - select to_timestamp('[template::util::date::get_property linear_date $due_date]','YYYY MM DD HH24 MI SS') from dual + select to_timestamp('[template::util::date::get_property linear_date $due_date]','YYYY MM DD HH24 MI SS')l @@ -69,34 +46,26 @@ - + - update cr_revisions - set content_length = :content_length - where revision_id = :revision_id + select content_revision__content_copy(:task_id,:revision_id) - + - update cr_revisions - set content_length = :content_length - where revision_id = :revision_id - - + update cr_revisions + set content = :filename, + mime_type = :mime_type, + content_length = :content_length + where revision_id = :revision_id + + - - - - select content_revision__content_copy(:task_id,:revision_id) - - - -