Community Member Profile

Recent Blog Comments By Leon

• SQL COUNT( NULLIF( .. ) ) Is Totally Awesome

  Posted on Apr 24, 2010 at 7:06 AM

  It is I think, I just figured it working on one server might mean it was standard. I guess not.... read more »

• SQL COUNT( NULLIF( .. ) ) Is Totally Awesome

  Posted on Apr 24, 2010 at 6:52 AM

  Hum, works for me, I guess it must be a non standard behaviour of mysql then. Well, that is fine by me, as long as it works. :)... read more »

• SQL COUNT( NULLIF( .. ) ) Is Totally Awesome

  Posted on Apr 23, 2010 at 8:17 PM

  Hum, getting to late for me to type properly. Anyway, one should even be able to do things like sum(r.status_ID = 1 or r.status_ID = 4 or r.status_ID = 5).... read more »

• SQL COUNT( NULLIF( .. ) ) Is Totally Awesome

  Posted on Apr 23, 2010 at 8:03 PM

  Wouldn't it work simply to do sum(property = 2), since preopert = 2 should evaluate to 1 if true, zero otherwise?... read more »