Index: openacs-4/packages/evaluation/sql/oracle/evaluation-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/sql/oracle/evaluation-create.sql,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/evaluation/sql/oracle/evaluation-create.sql 28 Dec 2004 19:50:36 -0000 1.1 +++ openacs-4/packages/evaluation/sql/oracle/evaluation-create.sql 17 Jan 2005 20:35:46 -0000 1.2 @@ -95,7 +95,7 @@ not null constraint evaluation_stu_evals_pid_fk references parties(party_id), - grade number(5,5), + grade number(5,2), show_student_p char(1) default 't' constraint evaluation_stu_evals_ssp_ck check (show_student_p in ('t','f')) @@ -257,7 +257,7 @@ where task_id = party_name.p_task_id; if v_number_of_members = 1 then return person.last_name(p_party_id)||', '||person.first_names(p_party_id); else - return acs_group.name(party_name.p_party_id); + return acs_group.name(p_party_id); end if; end party_name; @@ -280,9 +280,9 @@ evaluation_tasks et, acs_rels map where map.object_id_one = etg.group_id - and map.object_id_two = p_user_id + and map.object_id_two = party_id.p_user_id and etg.task_item_id = et.task_item_id - and et.task_id = p_task_id; + and et.task_id = party_id.p_task_id; return midato; end if; end party_id;