% chedsn = Application ("dbcon") EventID = request.QueryString("EventID") rid = request.QueryString("rid") SET cn = Server.CreateObject("ADODB.Connection") 'set up the cn.Open CHEDSN 'open the connection to if rid <> "" then strSQL = "Select count(*) as Total from events where eventno=126 and eventid='" & rid &"'" else strSQL = "Select count(*) as Total from events where eventno=126" end if SET oRs = cn.Execute(strSQL) 'Execute the SQL statement Registrants = oRs("Total") oRs.close set oRs = nothing AgeGroup = request.querystring("AgeGroup") Bib = trim(request.querystring("bib")) fname = trim(request.querystring("fname")) lname = trim(request.querystring("lname")) if rid <> "" then strSQL = "Select * from events where eventno=126 and eventid='" & rid & "' order by lname;" else strSQL = "Select * from events where eventno=126 order by lname;" end if SET oRs = cn.Execute(strSQL) 'Execute the SQL statement %>
When: September 15, 2018
Start Time: 9:00 AM
Start Location:
South Beach State Park
2018 Registrations: All | 5 Miler | Half Marathon
Total Registrants <%=registrants%>
Name | City, State | Shirt Size | Age Group | Race |
---|---|---|---|---|
<% = trim(oRs.Fields("LName")) & ", " & oRs.Fields("FName") %> | <% = trim(oRs.Fields("City")) & ", " & oRs("State") %> | <% = ucase(oRs.Fields("ShirtDesc")) %> | <% = oRs.Fields("AgeGroup") %> | <% = trim(oRs.Fields("EventDesc")) %> |
Twisted Pine Run Facebook Page
Ardor Adventures Facebook Page
Ardor Adventures Twitter Page
If you would like to know more about sponsorship levels and opportunities please contact us at info@ardoradventures.com