Re: DB Help Request

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
[download]

instead. Or even better to catch both cases use

WHERE unsubscribedby IS NULL OR unsubscribedby=''
[download]

Comment on Re: DB Help Request Select or Download Code

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=''` [download] Thanks a lot!! -- paul	[reply] [d/l]