Any way to do this in VBscript ??

[DOGWATCH]

Hello, I am writing a sql query that will return values
that I will display in a HTML table

it will be structuers somewhat like

LA CHI NY Total
wiget1 20 10 15 45
wiget2 10 5 20 35
wiget3 30 1 40 71

totals 60 16 75 151


The values for each city will be calcuated by my query
I am just wondering if there is something I can do in
vb script that will just sum up rows in a html table
and give me the totals as shown both vertically and horizontally.

I supose i could progam the query to sum that part up for me but I am wondering if you can just do this calucation on the web page.

Is there a way ???

 

[PHV]

If you use recordset it should be easy to implement.
What have you so far ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[Rob94]

If you have used multidimensional arrays before, you could implement them that way as well......

 

[Bullschmidt]

I'd say just create some extra totals variables that you calculate (add to) within your looping.

Best regards,
J. Paul Schmidt, Freelance ASP Web Consultant

http://www.Bullschmidt.com

ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...