Mark Jones, 2000
CyberStage
Toronto, Ontario

Technologies Used:

Server Side:
Active Server Pages
VBScript
SQL Server 7
Stored Procedures
TSQL
ActiveX Data Objects
ActiveX DLL's

Public Client Side:
VBScript
DHTML

Administrative Client Side:
Javascript
DHTML
ActiveX Controls (listboxes, radio buttons, checkboxes, textboxes)

Worked with Mark to design a bridge players' website - e-bridgemaster.com (now closed).

Created:

SQL Server 7 database
all necessary tables
stored procedures
used TSQL to create parameterized stored procedures
Content Management System - VBScript, ActiveX controls (listboxes, radio buttons, checkboxes, textboxes)

Created all Active Server Pages to pull information from the database to present it to the public and the Content Management System side of the site to handle the uploading and managing the content. This reduced the number of existing standard HTML pages to be displayed from hundreds to a small handful.

Used XML to define the stories to be uploaded to the site which were then parsed and put into the database.

The most difficult part of this project was designing a way to store and display what happened during a bridge game:

symbols for the different suits
what cards were in each hand
how the hands changed from one round to the next.