[NLRS] Web Site update

John P. Toscano [email protected]
Sun, 01 Feb 2004 22:13:10 -0600


Hello, all!

I spend most of Saturday and part of Sunday writing sofware for the NLRS 
web site.  After a lot of thinking and planning, and finally many hours 
of coding, I now have a database that stores contest Claimed Score data 
for the four major ARRL contests in January, June, August, and 
September, a public web page that can dynamically build a report of the 
data on the fly, and a private web form that I can use to quickly add 
more results to the database.  No more manual editing of a huge HTML 
source file and manually sorting rows in the table.  Hooray.  As a 
result of this, I have entered all the data that I have seen come past 
me on the reflector so far.  Adding another submission takes less than a 
minute and doesn't require me to FTP anything anywhere.  So it will be a 
lot more responsive than before.

Still to do is to build two more tables, one for the 10 GHz and Up 
Cumulative Contest, and one for the States (and Provinces) Above 50 MHz, 
since the data that they require are quite different than the other four 
contests.  But now that I have the first database working smoothly, the 
other two should come along pretty quickly.  (Famous last words, I know!)

 From the home page, click on the link to the January 2004 VHF SS 
Claimed Scores to see the new report.  I tried to make it look a lot 
like its predecessors, so you might not even notice anything different 
about it.  The differences are buried deep under the covers.  If you are 
impatient, you can go right to it:
 
http://www.nlrs.org/ContestScores/Admin/DisplayScores_VHF.php?Contest_ID=1&Year=2004

(At least, you can if the URL doesn't get split onto two lines by your 
mail reader.)

Congratulations to all the folks who had a good time in the contest. 
If, like me, you have not yet submitted your score log to the ARRL, get 
a move on!  If you have not posted your claimed score info here, please 
do so and I will update the web report pronto.

73 de W0JT