RecordCount 2
Dette script virker fint, bortset fra at den ikke looper rs2, det vil sige at den skriver det samme tal ved alle poster, hvad er der galt?SQL = \"SELECT DISTINCTROW BandNavn FROM lyrics where list = 1\"
set rs = Conn.Execute(SQL)
SQLC = \"Select Count(BandNavn) as found FROM lyrics where BandNavn = \'\" & rs(\"BandNavn\") & \"\'\"
set rs2 = Conn.Execute(SQLC)
%>
<table border=0 cellpadding=0 cellspacing=0><tr><td colspan=2 height=20 valign=top><font face=verdana size=1>Bands</font></td></tr>
<% do while not rs.EOF or rs.BOF
response.write \"<tr><td width=10></td><td><font face=verdana size=2><a href=\'index.asp?artist=\" & rs(\"BandNavn\") & \"\'>\" & rs(\"BandNavn\") & \"</a> <font face=verdana size=1>(\" & rs2(\"found\") & \")</td></tr>\"
rs.movenext
loop
response.write \"</table>\"
