Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Simon Free
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Simon Free

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 »