Ranglist for sidste gang :)

fandt selv ud af det:

i = 0
    While Not objRs.EOF
    if objrs("accepted") = ("1") then 
    i = i + 1 
      Response.Write("<tr>")
            Response.Write("<td><font size=2>" & i & "</td>")
            Response.Write("<td><font size=2>" & objRs("clanname_long") & "</font></td>")
            Response.Write("<td><font size=2>" & objRs("Won") & "</font></td>")
            Response.Write("<td><font size=2>" & objRs("Lost") & "</font></td>")
        Response.Write("</tr>")
    end if
    objRs.MoveNext()
    Wend

svar

d

<html>
<head>
    <title></title>
</head>
<body>

<%
    Set objConn = Server.CreateObject("ADODB.Connection")
    objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&amp;Server.Mappath("db/db.mdb")
   
    strSQL = "SELECT * FROM clans WHERE accepted = 1 ORDER BY won DESC, ORDER BY lost ASC"
    Set objRs = objConn.Execute(strSQL)   
%>
<table>
    <tr>
        <td><b>No</b></td>
        <td><b>Clan</b></td>
        <td><b>Won</b></td>
        <td><b>Lost</b></td>
    </tr>

<%
    i = 0
    While Not objRs.EOF   
    i = i + 1
        Response.Write("<tr>")
            Response.Write("<td>" & i & "</td>")
            Response.Write("<td>" & objRs("clanname_long") & "</td>")
            Response.Write("<td>" & objRs("Won") & "</td>")
            Response.Write("<td>" & objRs("Lost") & "</td>")
        Response.Write("</tr>")
    objRs.MoveNext()
    Wend
%>
</table>

</body>
</html>

//>Rune

Her er den kode jeg fik til at virke:
<%
i = 0
    While Not objRs.EOF
    if objrs("accepted") = ("1") then 
    i = i + 1 
      Response.Write("<tr>")
            Response.Write("<td><font size=2>" & i & "</td>")
            Response.Write("<td><font size=2>" & objRs("clanname_long") & "</font></td>")
            Response.Write("<td><font size=2>" & objRs("Won") & "</font></td>")
            Response.Write("<td><font size=2>" & objRs("Lost") & "</font></td>")
        Response.Write("</tr>")
    end if
    objRs.MoveNext()
    Wend
%>

eromaster> Det er mere oprigtig at valider det gennen din SQL statement, og oxo hurtigere!

//>Rune