Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Scott Stroz and Vicky Ryder and Ray Camden and Todd Sharp
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Scott Stroz@boyzoid ) , Vicky Ryder@fuzie ) , Ray Camden@cfjedimaster ) , and Todd Sharp@cfsilence )

Pedro

Member since Sep 14, 2009

Recent Blog Comments By Pedro

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

    Posted on Sep 14, 2009 at 6:51 PM

    Just amazing, I did something like this: SELECT 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 FROM payments WHERE fkclientid = 20503... read more »