Sql

[fantasma]

set rs_soma=objdb.execute("select sum(pontos),nome from teste GROUP BY nome")

erro

Error Type:

ADODB.Recordset (0x800A0CC1)

Item cannot be found in the collection corresponding to the requested name or ordinal.

/copa/pontuacao.asp, line 112

linha que esta dando erro

<% do while not rs_soma.eof%>

<tr>

<td height="26" width="531" bgcolor="#FFFFFF">

<div align="center"><font face="Verdana, Arial, sans-serif" size="2"><a href="ver_apostas.asp?email="><%=rs_soma("nome") %></a></font></div>

</td>

<td height="26" width="69" bgcolor="#FFFFFF">

<div align="center"><font face="Verdana, Arial, sans-serif" size="2"><%=rs_soma("pontos") %></font></div> </td>

<tr>

<% rs_soma.movenext %>

<%loop %>

[fercosmig]

sql = "select sum(pontos) as Total, nome from teste GROUP BY nome"

set rs_soma = objdb.execute(sql)

[kuroi]

tente assim:

set rs_soma=objdb.execute("select sum(teste.pontos) as pontos,nome from teste GROUP BY nome")