Query somma valori record

[[trodat]]

Scusate ho scritto questa query per la somma dei valori dei campi del dbase:

strSQL = "select sum(2005), sum(2006), sum(2007), sum(2008), sum(2009) from tabella9"
cn.execute strSQL

ma come faccio ad avere il totale stampato a video? grazie

[maximum]

strSQL = "select sum(2005) as tot1, sum(2006) as tot2, sum(2007) as tot3, sum(2008) as tot4, sum(2009) as tot5 from tabella9"
cn.execute strSQL 

response.write("Totale 1: " & objrs("tot1"))
response.write("Totale 2: " & objrs("tot2"))
response.write("Totale 3: " & objrs("tot3"))
response.write("Totale 4: " & objrs("tot4"))
response.write("Totale 5: " & objrs("tot5"))

objrs <-- il recordset specifico (non so come l'hai chiamato tu).

[maximum]

[DOPPIO]

Scusate...

[diegoctn]

[QUOTE]Originariamente inviato da [trodat]

strSQL = "select sum(2005), sum(2006), sum(2007), sum(2008), sum(2009) from tabella9"
cn.execute strSQL

strSQL = "select sum(2005) as a, sum(2006) as b, sum(2007) as c, sum(2008) as d, sum(2009) as e from tabella9"
.....
.....
.....
.....
rs("a")....rs("b")....etc

[[trodat]]

grazie ma in tutte e due i modi restituisce:

Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.

[diegoctn]

Sembra che manchi un campo......