You can do it a few ways, I think I'd put the old values and new
values in a bean, then put those beans in a map and call them "old"
and "new".
Pass that map to the update and change it to this:
<update id="updateUserApprover">
update user_approvers set region_name = #new.region:VARCHAR#,
division_name = #new.division:VARCHAR#,
where user = #old.user:VARCHAR#
and region = #old.region:VARCHAR#
and division=#old.division:VARCHAR#
</update>
Larry
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
