On 8/21/07, Guy Rouillier <guyr-ml1@burntmail.com> wrote:
> Well, I can't find a way to set a variable associated with a connection,
> so probably the easiest thing to do is to add an "updated_by" column to
> your regular table (i.e., the non-history version.) Then just include
> the userid from your webapp as the value for that column. Your history
> table can then be updated by just copying the entire row from the base
> table whenever an insert or update occurs.
Yes, I think this will be the easiest way, thanks!
--
regards,
Robin