in reply to DB Not UPDATE-ing

Your WHERE clause is looking for unsubscribedby = ''. Is it possible that unsubscribed by is null? If so, you will want to use
WHERE unsubscribedby IS NULL
instead. Or even better to catch both cases use
WHERE unsubscribedby IS NULL OR unsubscribedby=''

Replies are listed 'Best First'.
Re: Re: DB Help Request
by vbrtrmn (Pilgrim) on Sep 15, 2003 at 17:39 UTC

    Turned out to be the NULL issue, the code suggested by you works great!!

    WHERE unsubscribedby IS NULL OR unsubscribedby=''
    Thanks a lot!!

    --
    paul