asp Loop virker ikke helt!! HJÆLP
Hej alle :-)Mit problem er at jeg skal loop en liga fra min access tabel & det gider den også godt.
den looper alt det den skal fornær forskellige klan tags, der tager den kun en og gentager alle stederne.
Jeg har postet scriptet nede under, håber der er en der lige kan se fejlen.
som i kan se skal den tage kolonner fra 2 forskellige tabeller.
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("kb.mdb")
Conn.Open DSN
set rsE1337_league = conn.execute("SELECT * FROM e1337_league")
If Not (rsE1337_league.EOF and rsE1337_league.BOF) Then
set rsE1337_tag = conn.execute("SELECT klan_tag FROM klaner WHERE id="& rsE1337_league("Klan_id"))
If Not (rsE1337_tag.EOF and rsE1337_tag.BOF) Then
set rsE1337 = conn.execute("SELECT * FROM e1337_league Order by Seeding_id")
do while not rsE1337.EOF
%>
<form name="e1337" action="" method="post">
<td class="textNorm" bgcolor="#FFFFCC" width="100%"><%=rsE1337_tag("Klan_tag")%></td>
<td class="textNorm" bgcolor="#FFFFCC" align="center"><%=rsE1337("Position")%></td>
<td class="textNorm" bgcolor="#FFFFCC" align="center"><%=rsE1337("Kampe")%></td>
<td class="textNorm" bgcolor="#FFFFCC" align="center"><%=rsE1337("Rounds_os")%></td>
<td class="textNorm" bgcolor="#FFFFCC" align="center"><%=rsE1337("Rounds_dem")%></td>
<td class="textNorm" bgcolor="#FFFFCC" align="center"><%=rsE1337("+_-")%></td>
<td class="textNorm" bgcolor="#FFFFCC" align="center"><%=rsE1337("Vundet")%></td>
<td class="textNorm" bgcolor="#FFFFCC" align="center"><%=rsE1337("Uafgjort")%></td>
<td class="textNorm" bgcolor="#FFFFCC" align="center"><%=rsE1337("Tabt")%></td>
<td class="textNorm" bgcolor="#FFFFCC" align="center"><%=rsE1337("Points")%></td>
<td class="textNorm" bgcolor="#FFFFCC" align="center"><%=rsE1337("Seeding_id")%></td>
</tr>
<td class="textNorm" width="100%"><input type="text" name="kampe" maxlength="50" size="10"value="<%=rsE1337("Klan_tag")%>"></td>
<td class="textNorm" align="center"><%=rsE1337("Position")%></td>
<td class="textNorm"><input type="number" name="kampe" maxlength="5" size="3"></td>
<td class="textNorm"><input type="number" name="rounds_os" maxlength="5" size="3"></td>
<td class="textNorm"><input type="number" name="rounds_dem" maxlength="5" size="3"></td>
<td class="textNorm"><input type="number" name="+_-" maxlength="5" size="3"></td>
<td class="textNorm"><input type="number" name="vundet" maxlength="5" size="3"></td>
<td class="textNorm"><input type="number" name="uafgjort" maxlength="5" size="3"></td>
<td class="textNorm"><input type="number" name="tabt" maxlength="5" size="3"></td>
<td class="textNorm"><input type="number" name="points" maxlength="5" size="3"></td>
<td class="textNorm"><input type="number" name="seeding_id" maxlength="5" size="3"></td>
</tr>
<%
rsE1337.movenext
loop
%>
<tr>
<td colspan="11" align="center"><center><input type="submit" value=" Opdater E1337 "></center></td>
</tr>
</table>
</form>
<%
Conn.Close
Set Conn = Nothing
end if
%>
<%end if%>
hvorfor der er <%end if%> til sidst er fordi at den skal loop nogle andre ligaer nede under :-)
