Project - Chess Reporting Engine - xmarkvh.com

Figure 1. Reporting Engine Landing Page

Figure 2. Detail Page

Figure 3. Database Schema


Chess Reporting Engine Description About six of us started playing chess with each other in our office. We recorded the win-loss records of players on a white board. It worked for a while, but just looking at your record did little to give you an idea of things like trends, streaks, or any graphical representation of your relative abilities. (Not to mention it was annoying to climb up and redraw a specific square on the white board’s matrix.) Enter ASP. I cooked up a simple database schema (Figure 3) to hold the data, and started building up the front-end for data reporting and inputting. Figure 1 shows the landing page for the Chess Reporting Engine. Eventually I added rankings and a ladder. Each player has a detail page (Figure 2) which breaks out the results of individual games. It also contains some simple trend reporting and a histogram. The meat of the Chess Reporting Engine lies in Server-side ASP, with some creative SQL statements as well. You can browse around the Engine by clicking below, but I have disabled the results reporting piece. It will appear to have worked, but no row insert is being made. Link http://www.markvanhorn.com/progs/chess/

Skills Used
Client-side JavaScript	ASP
Server-side JavaScript	SQL
SQLServer	CSS

Completed For
Recreation
November 2000