Adding fields

[programmher]

What is the best way to add fields within Cold Fusion?<br><br>I have 6 fields (AmountDue1, AmountDue2,...AmountDue6).<br>I need the &quot;AmountSum&quot; field to reflect the sum of the other 6 &quot;AmountDue&quot; fields.&nbsp;&nbsp;What is the best way to do this so the &quot;AmountSum&quot; field changes to reflect the new total as user enters values in some of these fields?<br><br>This is probably SO simple; but I have never had to do this within Cold Fusion...

 

[SnakeHollywood]

When you do the update query do<br><br>amountsum = sum(amount1+amount2+amount3+etc)<br><br>the values being the formfields you submitted.<br> <p>Russ Michaels<br><a href=mailto:russ@satachi.com>russ@satachi.com</a><br><a href=

http://www.satachi.com>Satachi

Internet Development</a><br>For my personal book recommendations visit

http://www.satachi.com/books.html<br>

<br>

 

[programmher]

InternetOverlord,<br><br>Thanks for the suggestion; but, I want the &quot;AmountSum&quot; field to dynamically recalculate as the user enters values in the other &quot;AmountDue&quot; fields.<br><br>Would an ArraySum accomplish this for me?<br><br>