Find højeste tal

Udskriver her:
<%=tmpDateFrom%><%=Round(procent)%>%&nbsp;(<%=rs(0)%>)<br>
<% next %>

hmmm det højeste tal ? Hvordan skal de komme i række flg eller hvordan ?

<table width="100%"  border="0" cellspacing="0" cellpadding="2">
<%   
    set rs_count_all = conn.execute("select count(User_Session) from [Statistics] Where Site_Id = " & Site_Id & " AND Stat_date >= DATEADD(day, -10, getdate())")
   
    for f=0 to 9
      tmpDateFrom = dateAdd("d",-f,date())
      tmpDateTo = dateAdd("d",-f+1,date())
      set rs = conn.execute("select count(User_Session) from [Statistics] Where Site_Id = " & Site_Id & " AND Stat_date >= '"& tmpDateFrom  &"' and Stat_date< '"& tmpDateTo &"'")

    procent    =    Cdbl(rs(0))/Cdbl(rs_count_all(0))
    procent    =    Cdbl(procent)*100
%>
  <tr>
    <td width="20%"><%=tmpDateFrom%></td>
    <td width="60%">
<table width="<%=procent%>%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td id="stat">&nbsp;</td>
  </tr>
</table>   
    </td>
    <td width="10%"><%=Round(procent)%>%&nbsp;</td>
    <td width="10%">(<%=rs(0)%>)</td>
  </tr>
  <% next %>       
</table>

          </td>
          </tr>
      </table>

kan det her bruges?:

<table width="100%"  border="0" cellspacing="0" cellpadding="2">
<%   
    set rs_count_all = conn.execute("select count(User_Session) from [Statistics] Where Site_Id = " & Site_Id & " AND Stat_date >= DATEADD(day, -10, getdate())")
   
    for f=0 to 9
      tmpDateFrom = dateAdd("d",-f,date())
      tmpDateTo = dateAdd("d",-f+1,date())
      set rs = conn.execute("select count(User_Session) from [Statistics] Where Site_Id = " & Site_Id & " AND Stat_date >= '"& tmpDateFrom  &"' and Stat_date< '"& tmpDateTo &"'")

    procent    =    Cdbl(rs(0))/Cdbl(rs_count_all(0))
    procent    =    Cdbl(procent)*100

                    raekkefoelge = raekkefoelge & tmpDateFrom & ";"
                    raekkefoelgeprocent = raekkefoelgeprocent & procent & ";"
%>
  <tr>
    <td width="20%"><%=tmpDateFrom%></td>
    <td width="60%">
<table width="<%=procent%>%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td id="stat">&nbsp;</td>
  </tr>
</table>   
    </td>
    <td width="10%"><%=Round(procent)%>%&nbsp;</td>
    <td width="10%">(<%=rs(0)%>)</td>
  </tr>
  <% next %>       
</table>

          </td>
          </tr>
      </table>

<%   

raekkefoelge = split(raekkefoelge, ";")
raekkefoelgeprocent = split(raekkefoelgeprocent, ";")

                        max = raekkefoelge(0)
                        for i = 0 to (Ubound(raekkefoelge) - LBound(raekkefoelge)) - 1
                        if max < raekkefoelge(i+1) then
                                    max = raekkefoelge(i+1)
                        end if
                        next

                        response.write "det højeste tal er: " & max & "<br>"


                        maxprocent = raekkefoelgeprocent(0)
                        for i = 0 to (Ubound(raekkefoelgeprocent) - LBound(raekkefoelgeprocent)) - 1
                        if maxprocent < raekkefoelgeprocent(i+1) then
                                    maxprocent = raekkefoelgeprocent(i+1)
                        end if
                        next

                        response.write "det højeste procent tal er: " & maxprocent

%>

jep - smid et svar :o)

skal jeg da lige gøre...
værs'go!

/jsc

takker for 5 point :P

/jsc