Chris Humphries wrote:
you can do it in sql, if what you are doing irl is the example.
in dtml: <dtml-in sql_statement prefix="seq"> [hopefully dollar amount is just a number] <dtml-call "REQUEST.set('total', total + seq_item['dollar_amount'])">
oops: <dtml-call "REQUEST.set('total', _.int(total) + _.int(seq_item['dollar_amount']))">
</dtml-in>
though a python script would be better to do this in: total=0 resultset=content.sql_method() if len(resultset) > 0: for result in resultset: total += int(result.dollar_amount) return total
D. Rick Anderson wrote:
I need to total variable from a dtml-in and give the result at the bottom. I can't seem to figure out what needs to be done to get this result. If I have the following:
<dtml-in sql_statement> <table> <tr> <td> <dtml-var dollar_amount> </td> </tr> </table> </dtml-in>
How do I total all the iterations of dollar_amount? Is there a way in dtml to put a variable in that stores a running total?
TIA
Rick
-- Chris Humphries Systems Analyst DevIS 540.537.3904