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() 2010 (Minneapolis, MN) with: James Morrow

Dan Farrell

Member since Dec 29, 2010

Recent Blog Comments By Dan Farrell

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

    Posted on Dec 29, 2010 at 9:49 PM

    >sum(case when paytype = 1 then amount else 0 end) as bpay, >sum(case when paytype = 2 then amount else 0 end) as paypal, >sum(case when paytype = 3 then amount else 0 end) as ccard For the record, a better way to do conditionals inside sums and counts might be: sum(if(paytype=1, amount,... read more »