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 Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Hugo Sombreireiro

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 »