<% 'VB Script (ASP) dim db, rs, sql set db = Server.CreateObject("ADODB.connection") set rs = server.CreateObject("ADODB.recordset") 'Open the database connection db.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("fpdb\ltcdb.mdb") %> LTC - Results Query

LINCOLN TRACK CLUB
LINCOLN, NEBRASKA
Home of the Lincoln Marathon & Half Marathon (May 6, 2012)  - Registration Opens December 2011

Pace Calculator

  Results     Calendar    Pictures    Comments

Links

MAIN

RESULTS

ABOUT LTC

MEMBERSHIP

LTC RACES
>

State Farm

>

Novartis

Mayor's Run

>

Marathon

>

Havelock

>

Lincoln Mile

>

Thunder

>

Buffalo

>

Governor's Cup

 

Holiday Run

CALENDAR

Kids Grand Prix

GROUP RUNS

COMMENTS

LTC Race Results Query

<% if request("name")<>"" then sql = "select * from ltcdb where name like " + "'" + request("name") + "%' order by " + request("sort1") + ", " + request("sort2") + ", " + request("sort3") 'Select records from the database matchin criteria rs.Open sql, db if rs.EOF then Response.Write "No Records Found" else while not rs.EOF 'For Each Record, create a table row. Response.Write "" & vbcrlf Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" & vbcrlf Response.Write "" & vbcrlf rs.MoveNext wend end if rs.Close db.Close set rs=nothing set db=nothing end if %>
YEAR RACE NAME TIME PACE
" & vbcrlf Response.Write rs("Year") Response.Write "" & vbcrlf Response.Write rs("Race") Response.Write "" & vbcrlf Response.Write rs("Name") Response.Write "" & vbcrlf Response.Write rs("Time") Response.Write "" & vbcrlf Response.Write rs("Pace") Response.Write "
" Response.Write "


To search LTC results database for individual results, enter name below.  
Note: Database gets updated once per year usually in November.
NAME (last, first) or partial name
Sort by: