Adding up total cost - ASP while

Question

Hey, i am simple cart page where it displays the content in table form and I am trying to find a way to add up the Cost column then display the total price at the bottom. Does anyone have any suggestions how to do that? The part that is confusing me is that it the table is dynamically created via ASP.

My code can be found here: http://pastie.org/341676

Any suggestions?

Thanks so much,

Ryan

Answer 1

First off, that is a special kind of painful (asp classic in all its glory)

What you need is another variable to hold your values, and then sum it in each loop iteration

While Not objRS.EOF
    totalCost = trim(objRS.Fields("quantity"))*trim(objRS.Fields("p_price"))
    absoluteTotal = absoluteTotal + totalCost

...

Wend

Response.Write absoluteTotal

That will output a sum of all the totals, although you would probably want to format it better with html and whatnot