When you are running a sum query, I would imagine the only time you're
getting nulls is if there's no rows returned, right? Otherwise, the sum
should be 0.
If so, can't you just do a <CFIF myQuery.recordcount EQ 0> <CFSET myVar
= 0></CFIF>
?
Tim Starling wrote:
How would I best do the following: When I run a query to get a sum, if
there is no value returned, set the value to 0. I’ve tried <cfparam>
and it doesn’t seem to work – I guess it considers null a value.
Thanks,
Tim
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
