postgresql7.4
UPDATE cc_uos_assess_method
SET name = :name,
identifier = :identifier,
description = :description,
weighting = :weighting
WHERE method_id = :method_id
UPDATE acs_objects
SET modifying_user = :modifying_user,
modifying_ip = :modifying_ip,
package_id = :package_id
WHERE object_id = :method_id