EASY ANSWER

nlicata · August 4th, 2003, 11:17 AM

OK I am an idiot - someone please tell me how to get the sum of a column through asp in a db...

To explan; In excel (old days) it would be =sum(a1:a5)

I need to pull data from an sql db - get all records after filtering (done) but then display records and above it put the totals...

Example...
A B C
____ ____ ____
Item A cost 10 5 5
item B cost 1 6 15

This data displays great from DB but how would I total the inidividual columns. The data manipulation is more complicated then that but if this question were answered I could get the rest... Thanks in advance to anyone answering...

Nick

ALoPresto · August 4th, 2003, 03:24 PM

It should be something like

Code:

objCommand.CommandText = "SELECT Sum(columnName) as "varSum" FROM tableName"
Set objRS = objCommand.Execute
Response.write objRS("varSum")

That will total the column and write it. Hope this helps. Andy

Andy
AIM: LoPrestoAtWork

Trusant Technologies, LLC

nlicata · August 5th, 2003, 09:32 AM

thanks!

nlicata · August 5th, 2003, 01:42 PM

Does this code produce a sum of the records in the record set (filtered) or the sum of the specified column in the entire column (unfiltered)....???

Please, Thanks,
Nick

ALoPresto · August 8th, 2003, 02:49 PM

This produces a sum of all non-null values in the column. This is because it is calculated within SQL Server, before it is passed to the recordset. HTH

Andy
AIM: LoPrestoAtWork

Trusant Technologies, LLC