Community Member Profile
Russell Fox
Member since Mar 17, 2010
- Profile: /members/5672-Russell-Fox.htm
- Comments: 1
- Points: 9
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)<... read more »
