Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2014 (Bloomington, MN) with: Emily Christiansen and Simon Free and Dave Ferguson and Joel Hill and Dan Wilson and Jeff McDowell and Brian Rinaldi
Ben Nadel at cf.Objective() 2014 (Bloomington, MN) with: Emily Christiansen@egchristiansen ) , Simon Free@simonfree ) , Dave Ferguson@dfgrumpy ) , Joel Hill@Jiggidyuo ) , Dan Wilson@DanWilson ) , Jeff McDowell@jeff_s_mcdowell ) , and Brian Rinaldi@remotesynth )

Russell Fox

Member since Mar 17, 2010

Recent Blog Comments By Russell Fox

  • Testing For NULL Values In A ColdFusion Query Result Set

    Posted on Mar 17, 2010 at 4:13 PM

    To get around the empty strings in an UPDATE statement I pretended the variable was a string by enclosing it in single quotes, CAST it to an integer, let it convert empty strings to zeroes, and used NULLIF to change the zeros to NULLs: SET [Field1] = NULLIF(CAST('#Form.Field1#' as INT), 0) It shou... read more »