HOW TO SUM A FIELD VALUE FROM A TABLE

[alexfusion]

Hello everyone,
This is a simple question:
I have a table with a field containing tax values in each row.
I have to sum all of this field values to get a total value.
That's fine.The problem is when one particular field is empty.Of course I doing an aritmethic operation with an empty field and I get an error.
Could anyone tell me how to solve this problem so if the field is empty the value to add is 0?

Many thanks

alexfusion

mixale@hotmail.com

 

[Silvano]

try something like this:

<cfparam name=&quot;total&quot; default=&quot;0&quot;>

now, put this in the query loop:

<cfif queryValue EQ &quot;&quot;>
<cfset newQueryValue = &quot;0&quot;>
<cfset total = total + newQueryValue>
<cfelse>
<cfset newQueryValue = queryValue>
<cfset total = total + newQueryValue>
</cfif>