Re: [GENERAL] Updating rows (automatically) that are selected

2006-01-24 Thread Bruno Wolff III
On Wed, Jan 18, 2006 at 14:26:28 -0700, Assad Jarrahian <[EMAIL PROTECTED]> wrote: > Hello, > I have a table called X > it contains 3 fields of importance(amongst others). > time (timestamp), snooze (int) , inbox (int) > > The time column sometimes has null values. > What I want is that every

[GENERAL] Updating rows (automatically) that are selected

2006-01-18 Thread Assad Jarrahian
Hello, I have a table called X it contains 3 fields of importance(amongst others). time (timestamp), snooze (int) , inbox (int) The time column sometimes has null values. What I want is that every time a row is selected, if the time is a null value, it is set to now() and snooze is set to 0 and