Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2009 (Minneapolis, MN) with: Cameron Childress
Ben Nadel at cf.Objective() 2009 (Minneapolis, MN) with: Cameron Childress@cameronc )

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 »