It might help, haven't thought it through, but Val() will turn an empty string into 0. If your logic works for an empty string being 0 then you should be good to go.
Adrian Got a ColdFusion error? Add it to the DB at http://cferror.org/ -----Original Message----- From: Ben Conner Sent: 17 November 2008 00:38 To: cf-newbie Subject: Using the Max Function when one or more fields are null Hi, I was trying to use the MAX function in a CFIF with two arguments when the 2nd one was null. CF threw an error upon encountering that (The value "" cannot be converted to a number). Is there a graceful way around this? Thanks! --Ben ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4166 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
