Server-Side Scripts

The following scripts are in VBScript and specifically developed for Server-Side ASP Development.

Most scripts are in Function form, making them easy to add to your pages without much modification.

Database        Easy DB Connection Automate the way your connection objects are created and database connection completed. Strip Incompatible Characters Certain quotation marks cause problems for SQL statements when submitted to the database.   This script strips those unexpected quotes as well as various other problem characters. Testing DB Connections Reduce page errors by making sure your database connection is still active before executing a connection object command.

Look and Feel / Navigation        Building Select Boxes One of two different ways to build an HTML Drop down box (option or listbox).   This script offers more features, but is less efficient than the script I normally use. Tabbed Navigation Automatically create a tab-style navigation bar to control your <FRAME> website. Tabs react to mouse events by changing color of background and text. Hyperlink Builder If you are building a large number of hyperlinks based on information in a database, this function can automate the process. Build Yes-or-No Box Automate the creation of select boxes which return the value of 'Y' or 'N' if 'Yes' or 'No' are selected respectively. Display/Submit HTML Code Modify HTML tags and code so it can be displayed correctly as "text" rather than rendered by the web browser.  Also converts html code to be saved in a database. Time Select Box This function builds an HTML Select box of times.

Date/Time Functions        A 'CDate' for Oracle SQL Oracle will often crash when sending dates in the form of strings to the database.  This function formats your text correctly by adding the Oracle "TO_DATE()" function to your SQL string. VB FormatDateTime This works exactly like the Visual Basic "formatDateTime()". 24 to AM/PM Converter This returns a string with either "AM" or "PM" based on the 24-hour number submitted. 24hr-to-12hr Converter This function takes a number between 0 & 24 and converts it to an 1-12 AM/PM string. 2-Digit to 4-Digit Year This function adds 19 or 20 to any 2 digit year. Format Time Intervals Format "3.55 days" into "3 days, 12 hours, 30 minutes" Format

Security        Get User's NT ID One way to validate security is capturing the User's NT ID.  This script grabs the user's ID and exposes it for validation.

Other        Browser is I.E. Determine on the Server-Side if the visitor is using Internet Explorer. HTML Comment Blocks Build HTML Comment blocks for code documentation or debugging.