ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the reques

[dwg23]

hello,
i am trying to recode an old ASP Site and am having a problem with a calculation.
i am attempting to divide games played by total wins with the below code.
the problem is when I dim help and do the calculation for help and then try to display the result i get the
ADODB.Recordset error '800a0cc1'

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

any help would be great.

dim thetotal,per
thetotal = CLng(RS("standings_Won"))+ CLng(RS("standings_Lost"))
help = thetotal/CLng(rs(standings_won)) %>
<tr>
<td align="left">
<font face="Arial" Size="1">
<a href="team1.asp?SEARCH=ID&amp;ZONE=<%=RS("ZoneID")%>&amp;TEAMID=<%=RS("TeamID")%>&amp;leagueid=<%=leagueid1%>">
<%=RS("TeamName")%></a>
</font>
</td>
<td align="center">
<font face="Arial" Size="2">
<%=RS("standings_Won")%>
</font>
</td>
<td align="center">
<font face="Arial" Size="2">
<%=RS("standings_Lost")%>
</font>
</td>
<td align="center">
<font face="Arial" Size="2">
<%= thetotal%>
</font>
</td>
<td>
<font face="Arial" Size="2">
<%= help%>
</font>
</td>
</tr>
<%RS.MoveNext
Loop
RS.close%>

 

[gmmastros]

I think you are missing quotes on this line:

help = thetotal/CLng(rs(standings_won)) %>

help = thetotal/CLng(rs([!]"[/!]standings_won[!]"[/!])) %>

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[dwg23]

WOW! i am totally blind!
Thanks!

 

[gmmastros]

Forest... trees... sometimes all you need is another pair of eyes looking at the problem.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom