<%@LANGUAGE="VBSCRIPT"%> <% Dim rcl Dim rcl_numRows Set rca = Server.CreateObject("ADODB.Recordset") rca.ActiveConnection = MM_tecno12_STRING rca.Source = "SELECT distinct Cat FROM ResultatsBeniarjoCursa13" rca.CursorType = 0 rca.CursorLocation = 2 rca.LockType = 1 rca.Open() rcl_numRows = 0 %> <% Dim rz__CAR rz__CAR = "Veterans E Fem" If (Request.Form("busca") <> "") Then rz__CAR = Request.Form("busca") End If %> <% Dim rz Dim rz_numRows Set rz = Server.CreateObject("ADODB.Recordset") rz.ActiveConnection = MM_tecno12_STRING rz.Source = "SELECT * FROM REsultatsBeniarjoCursa13 WHERE Cat='" + Replace(rz__CAR, "'", "''") + "' ORDER BY PC" rz.CursorType = 0 rz.CursorLocation = 2 rz.LockType = 1 rz.Open() rz_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rz_numRows = rz_numRows + Repeat1__numRows %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables Dim rz_total Dim rz_first Dim rz_last ' set the record count rz_total = rz.RecordCount ' set the number of rows displayed on this page If (rz_numRows < 0) Then rz_numRows = rz_total Elseif (rz_numRows = 0) Then rz_numRows = 1 End If ' set the first and last displayed record rz_first = 1 rz_last = rz_first + rz_numRows - 1 ' if we have the correct record count, check the other stats If (rz_total <> -1) Then If (rz_first > rz_total) Then rz_first = rz_total End If If (rz_last > rz_total) Then rz_last = rz_total End If If (rz_numRows > rz_total) Then rz_numRows = rz_total End If End If %> <% ' *** Recordset Stats: if we don't know the record count, manually count them If (rz_total = -1) Then ' count the total records by iterating through the recordset rz_total=0 While (Not rz.EOF) rz_total = rz_total + 1 rz.MoveNext Wend ' reset the cursor to the beginning If (rz.CursorType > 0) Then rz.MoveFirst Else rz.Requery End If ' set the number of rows displayed on this page If (rz_numRows < 0 Or rz_numRows > rz_total) Then rz_numRows = rz_total End If ' set the first and last displayed record rz_first = 1 rz_last = rz_first + rz_numRows - 1 If (rz_first > rz_total) Then rz_first = rz_total End If If (rz_last > rz_total) Then rz_last = rz_total End If End If %> Classificació per Categories 3ª Cursa Popular Beniarjó
Som Esport
3ª Cursa Popular Beniarjó

CLASSIFICACIÓ PER CATEGORIES 3ª CURSA POPULAR BENIARJÓ

Data: 10 de Novembre de 2013
Distància: 7,9 Km

Organitza: Ajuntament de Beniarjó

+ CLASSIFICACIONS >>>

Sel·lecciona la teua categoria  

<%=(rz_total)%> corredors arribats en la categoria <%=(rz.Fields.Item("Cat").Value)%>    

Cronometratge www.somesport.com

<% While ((Repeat1__numRows <> 0) AND (NOT rz.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rz.MoveNext() Wend %>
Meta
1er Pas Per Meta
Meta
P. Cat
Nom
Categoria
Club
P.Gral
P.Gral
P:Cat
Temps
T/Km
Temps
T. Real
T/Km
<%=(rz.Fields.Item("PC").Value)%>
<%=(rz.Fields.Item("Nom").Value)%>
<%=(rz.Fields.Item("Cat").Value)%>
<%=(rz.Fields.Item("Club").Value)%>
<%=(rz.Fields.Item("PG").Value)%>
<%=(rz.Fields.Item("G1").Value)%> <%=(rz.Fields.Item("C1").Value)%>
<%=(rz.Fields.Item("T1").Value)%>
<%=(rz.Fields.Item("M1").Value)%>
<%=(rz.Fields.Item("T").Value)%>
<%=(rz.Fields.Item("TN").Value)%>
<%=(rz.Fields.Item("M").Value)%>

<% rca.Close() Set rca = Nothing %> <% rz.Close() Set rz = Nothing %>