Not "ifnull" ... I'ts "isnull" .. ISNULL(col,0) AS alias
Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Will Tomlinson [mailto:[email protected]] Sent: Saturday, October 24, 2009 6:04 PM To: cf-talk Subject: Re: Trouble with query... > i'm not very familiar with sql server syntax, but would something like > this work? > > SELECT IFNULL(cpn.numCoupons,0) as numCoupons, couponcode, > THEORDERDATE Hmm. didn't work. SQL server didn't like it. :( I just simplified it and didn't break it down by the day. I got somethin that'll work for now. Thanks jessica! Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327653 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
