Maybe doing a CAST on the column will help? CF may be seeing the nulls and assuming the column is a varchar instead of an int.
On Dec 28, 2007 11:28 AM, Flesher, Rob [USA] <[EMAIL PROTECTED]> wrote: > 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:295491 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
