On 10/8/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Charlie Griefer wrote: > > heh. i suggested coalesce() over isnull() just to keep it portable. > > > > but agreed that isnull() is more "readable" than both the CASE and > > coalesce() suggestions :) > > Really? And how about when you want to check 3 arguments?
generally speaking, i find isNull() to be a bit more descriptive as to what it actually does than coalesce(). In this particular instance, both would work, and if i knew that portability was not (and likely would not become) an issue, i'd go with isnull() because it's more descriptive. if there were 3 (or more) arguments, i'd find coalesce() to be more readable than nested isNull() statements. i was referring specifically to the issue that was presented (as well as the responses to that particular issue) :) -- Charlie Griefer ================================================ "...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290585 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
