This is the second time out of three that I get "filtered out". Couldn't this filter be made a little bit smarter?
At 10:00 24.10.2001, you wrote: >Your message cannot be posted because it appears to be either spam or >simply off topic to our filter. To bypass the filter you must include >one of the following words in your message: > >database,sql,query,table > >If you just reply to this message, and include the entire text of it in the >reply, your reply will go through. However, you should >first review the text of the message to make sure it has something to do >with MySQL. Just typing the word MySQL once will be sufficient, for example. > >You have written the following: > >Hi Jeff > >I think that I had the same problem once. The problem is >that in a row containing NULLs almost every statement is FALSE. > >In your case: > >d.entrydate > date_add(now(), interval -7 day ) > >try: > >d.entrydate is null or (d.entrydate > date_add(now(), interval -7 day )) > >instead. > >Sorry, I didnt try this myself. No time at the moment. > >Hope it helps anyay. > >Matthias > > > >Example 1. - Nulls returned. > >----------------- > >select u.username Who, ifnull(count(d.username),0) Logs > >from users as u natural left join details as d > >where u.disabled='N' > >group by u.username > >order by 2 desc > > > >Who Logs > >------- -------- > >bob 9 > >sarah 8 > >frank 3 > >jane 0 > >jack 0 > > > >Example 2. - No Nulls returned. > >----------------- > >select u.username Who, ifnull(count(d.username),0) Logs > >from users as u natural left join details as d > >where u.disabled='N' > >and d.entrydate > date_add(now(), interval -7 day ) > >group by u.username > >order by 2 desc > > > >Who Logs > >------- -------- > >bob 7 > >sarah 3 > >frank 1 > > >Matthias Ragaz >Informatik - Entwicklung >Schweizerische Bibliothek für Blinde und Sehbehinderte >Albisriederstasse 399 >CH-8047 Zürich >Schweiz >Tel.: +41 1 491 25 55 >Fax: +41 1 492 64 75 >------------------------------------------------------ ------------------------------------------------------ Matthias Ragaz Informatik - Entwicklung Schweizerische Bibliothek für Blinde und Sehbehinderte Albisriederstasse 399 CH-8047 Zürich Schweiz Tel.: +41 1 491 25 55 Fax: +41 1 492 64 75 ------------------------------------------------------ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
