Re: Why isn't this working?

[John Frank]

Peter Brawley Wrote:
-------------------------------------------------------
> Best to read about Triggers before trying to write
> one, eg an Update Trigger can't issue an Update on
> the table for which it's define, it has to use SET
> syntax.
>
> But why didn't you just default the timestamp
> column with ON UPDATE TIMESTAMP?

That's not what I asked to do. I asked to change a field in the table `Lighting` when changes are made on a completely different table `Lighting Schedule`, so using a default value on the ladder table won't help me here.