Index: openacs-4/packages/organizations/organizations.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/organizations.info,v diff -u -r1.6 -r1.7 --- openacs-4/packages/organizations/organizations.info 25 Jun 2004 17:09:54 -0000 1.6 +++ openacs-4/packages/organizations/organizations.info 25 Jul 2004 11:26:28 -0000 1.7 @@ -7,7 +7,7 @@ f f - + Jon Griffin Jade Rubick Implementation of HR-XML organizations datamodel. @@ -20,7 +20,7 @@ what needs to be updated to make things work correctly [Jade Rubick]. - + Index: openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql 25 Jun 2004 17:09:54 -0000 1.4 +++ openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql 25 Jul 2004 11:26:28 -0000 1.5 @@ -167,7 +167,7 @@ reg_number = p_reg_number where organization_id = p_organization_id; - raise NOTICE ''Updating - organization - %'',organization_id; + raise NOTICE ''Updating - organization - %'',p_organization_id; return v_return; end;' language 'plpgsql'; Index: openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.5d1-0.5d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.5d1-0.5d2.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.5d1-0.5d2.sql 25 Jul 2004 11:26:28 -0000 1.1 @@ -0,0 +1,28 @@ +-- raise statement said organization rather than p_organization + +create or replace function organization__set (varchar,varchar,text,integer,varchar) +returns integer as ' +declare + p_legal_name alias for $1; -- comment + p_name alias for $2; -- comment + p_notes alias for $3; -- comment + p_organization_id alias for $4; -- comment + p_reg_number alias for $5; -- comment + + v_return integer := 0; +begin + + update organizations + set + legal_name = p_legal_name, + name = p_name, + notes = p_notes, + organization_id = p_organization_id, + reg_number = p_reg_number + where organization_id = p_organization_id; + + raise NOTICE ''Updating - organization - %'',p_organization_id; + +return v_return; +end;' language 'plpgsql'; +