Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.


Member since Dec 27, 2011

Recent Blog Comments By Adam

  • Using NULLIF() To Prevent Divide-By-Zero Errors In SQL

    Posted on Dec 27, 2011 at 3:18 PM

    I'm attempting to use this feature when calculating the average for a value, but I'm not certain if my syntax is correct as CF throws an error: avg (isNull((((docunitprice * orderqty)-((c.avglaborcost + c.avgburdencost + c.avgmaterialcost + c.avgsubcontcost + c.avgmtlburcost)*d.orderqty))/ nullif(d... read more »