I'm trying to come up with a strategy for updating multiple tables from a 
single html form.

One idea I've had is to map form element names to columns/tables and then 
execute one sql update per table.

Can anyone suggest a different/better way to tackle this?
Thanks in advance.

why not use a stored procedure or Transaction to do it for you.

At 15:14 19/11/02 +0000, you wrote:
>I'm trying to come up with a strategy for updating multiple tables from a
>single html form.
>
>One idea I've had is to map form element names to columns/tables and then
>execute one sql update per table.
>
>Can anyone suggest a different/better way to tackle this?
>Thanks in advance.