How to retrieve data from an Oracle database with VBscript

(This post was originally published September 21, 2006)

This article will give you a brief example of how to create a VBscript process that can retrieve data from an Oracle database. The techniques presented here can more than likely be adapted to connect to other databases as well. I’ll walk through a script that I wrote to solve a small problem with a web-based application that I support. The finished script will also touch upon techniques for logging and setting the date/time from within a VBscript process. Continue reading How to retrieve data from an Oracle database with VBscript

Supplemental APA 9 Ball scoresheets

(This post was originally published March 07, 2006)

I play pool (billiards) in a American Poolplayers Association (APA) league here in San Diego and developed a couple of supplemental 9 Ball scoresheets to assist in the scorekeeping task.

Keeping score in 9 Ball matches involves tracking balls pocketed, innings, dead balls and defensive shots…quite a bit to keep track of, but not too bad if you pay attention. Both teams playing in the match keep score and should compare their results after each rack to make sure they both agree. If the scores are different, it causes delays in the match while “who pocketed what” is figured out. It also can cause the players in the match some undo distraction and a break in their rhythm while it is sorted out. Continue reading Supplemental APA 9 Ball scoresheets