Display Query

[ttttttttttttttt]

Ciao a tutti,
mi sto perdendo in un bichiere d'acqua, io eseguo qeusta query

set ors2 = server.createobject("ADODB.Recordset")
srtsql2 = "SELECT SUM(oretotali) FROM interventi where tecnico ='" + tecnico + "'"


come faccio per fare il display del valore???

se scrivo

<td><%Response.write ("[b]<font face=Arial, Helvetica, sans-serif size=1>"&ors2("oretotali")) %>
</td>

giustamente mi da errore...

[diegoctn]

"SELECT SUM(oretotali) as qqqqq  FROM interventi where tecnico ='" + tecnico + "'".............
><%Response.write ("[b]<font face=Arial, Helvetica, sans-serif size=1>"&ors2("qqqqqq ")) %>
</td>

[Roby_72]

srtsql2 = "SELECT SUM(oretotali) AS oretotali  FROM interventi where tecnico ='" + tecnico + "'"

Roby

[diegoctn]

Roby preceduto di un millesimo di secondo.......

[Roby_72]

[ttttttttttttttt]

aaaaa... ecco l'inghippo!!
thanks!

[ttttttttttttttt]

urca....mi da questo errore

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Circular reference caused by alias 'oretotali' in query definition's SELECT list.

[Roby_72]

"SELECT SUM(oretotali) as PIPPO FROM interventi where tecnico ='" + tecnico + "'".............
><%Response.write ("[b]<font face=Arial, Helvetica, sans-serif size=1>"&ors2("PIPPO")) %>
</td>

[diegoctn]

Allora sei monello...............usa qqqqqq

[ttttttttttttttt]

thanks!!