All, Please forgive me if you get this twice, as it did not appear to post the first time. I am having an issue with cold fusion query of queries when upgrading to MX7. Previously, when doing a SUM(querycol) in a query of queries when all the values of the column were null, the sum would return a 0. In MX7, it is returning a blank string, causing all calculations to error out. Can someone tell me if CF query of queries has a function similar to oracle's NVL? Basically, what I need to do is NVL(SUM(querycol), 0) to insure any null values return as a 0. If a function like this doesn't exist, how would you recommend I deal with this issue? Thanks, Rob Flesher
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295486 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
