 |
| |
 |
|
|
| |
|
|
|
|
|
|
 |
|
2001
Hilton Tournament
Professional Payoffs
|
|
<%
Set MyConn=Server.CreateObject("ADODB.Connection")
'*** Select Connection Method ***
MyConn.Open "dsn=icba;database=hilton;" & "UID=hiltonopen;PWD=hilton;"
SQL = "select * FROM scores where eventid=3 and flightid=4 "
SQ = "select flightsponsor, flightid from scores where eventid=3 and flightid=4 order by nettotal"
SQL2 = "select * FROM scores where eventid=3 and flightid=5 "
SQ2 = "select flightsponsor, flightid from scores where eventid=3 and flightid=5 order by nettotal"
SQL3 = "select * FROM scores where eventid=3 and flightid=6 "
SQ3 = "select flightsponsor, flightid from scores where eventid=3 and flightid=6 order by nettotal"
SQL4 = "select * FROM scores where eventid=3 and flightid=7 "
SQ4 = "select flightsponsor, flightid from scores where eventid=3 and flightid=7 order by nettotal"
SQL5 = "select * FROM scores where eventid=3 and flightid=8 "
SQ5 = "select flightsponsor, flightid from scores where eventid=3 and flightid=8 order by nettotal"
SQL6= "select * FROM scores where eventid=3 and flightid=9 "
SQ6 = "select flightsponsor, flightid from scores where eventid=3 and flightid=9 order by nettotal"
SQL7= "select * FROM scores where eventid=3 and flightid=10 "
SQ7= "select flightsponsor, flightid from scores where eventid=3 and flightid=10 order by nettotal"
Set RS = MyConn.Execute(SQL)
set rs2 = myconn.execute(sq)
%>
<%
rs2.close
RS.Close
MyConn.Close
set rs2=nothing
Set RS = Nothing
Set MyConn = Nothing
%>
|
| Player |
Payoff
($) |
| Gates,
Scott |
7,500 |
| Murphy, Ryan |
3,125 |
| Gemoets, Ralph |
3,125 |
| Kortan, Brian |
1,750 |
| Brubaker, Jason |
1,300 |
| Navarro, Mario |
1,100 |
| Bacon, John C |
700 |
| Taylor, Jason |
700 |
| Koesters, Dan |
700 |
| Blevins, Gary |
450 |
| Hidalgo, Tony |
450 |
| Bourg, James (Tad) |
450 |
| Fulwiler, Jeff |
400 |
| Holtby, Paul |
400 |
| Sosa, John |
400 |
| Gonzales, Johnny |
400 |
| Braxton, David |
400 |
| Ciolek, Mike |
400 |
| Robertson, Greg |
250 |
| Storey, Tom |
250 |
| Dickson, James |
250 |
| Kortan, Rob |
250 |
| Mackin, Larry |
250 |
| Benavidez, Marc |
233 |
| Price, Kevin |
233 |
| Harvey, Bill |
233 |
| Krause, Damon |
200 |
| Gonzales, Patrick |
200 |
| Delgadillo, Luis |
200 |
| Nunez, Daniel A |
200 |
|
|
