Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at cf.Objective() 2013 (Bloomington, MN) with:

Baylink

Member since Dec 11, 2008

Recent Blog Comments By Baylink

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

    Posted on Dec 10, 2008 at 3:12 PM

    So, is there anyway to get NULLIF to return the null if they *aren't* equal? It's awfully difficult to invert a null, and worse inside a select...... read more »

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

    Posted on Nov 19, 2008 at 9:44 AM

    Oh, and the part I meant to include and forgot: "yes, this works in MySQL 5". :-) I'm sure it would work in PgSQL as well, which is what I use by preference. And I'm so sorry you had to *pay* for *your* DBMS. :-)... read more »

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

    Posted on Nov 18, 2008 at 5:42 PM

    This *is* huge; it just saved me massive time in writing a correlated subquery. Why is it so hard to find out what COUNT() *does* with it's argument? It doesn't seem to be documented really well.... read more »