Lee's Code - A Web Programmer's Toolbox

Refresh Opening Page

Fri, 18 Feb 2010 11:50:22 -0700

This is a very simple bit of Javascript which you can add to the tag of a html page which has been opened by another page. When the called page is closed, the opening page is automatically refreshed. This is the simplest method I know of accomplishing this.

Detect Record State and Database State. Close recordset and database

Tue, 07 Dec 2009 10:14:48 -0700

This code snippet illustrates how to detect an open recordset and close it. Same for an open database connection.

If you do not first detect the state of the recordset or the database and you attempt to close it, you will get an error if it is not open. This code eliminates the error by first deetecting ste state of the recordset or the dataabase connection.

SQL Injection Data Cleaner

Thu, 01 Oct 2008 14:38:14 -0700

This is a simple input field cleaner to help prevent SQL Injection problems. SQL Injection occurs when a hacker fills out a form on your web site or posts data to a script. If the script which accepts and processes the data reads or writes to a SQL database, the hacker can include SQL commands. Those commands can insert data to your database and/or can output details about the tables and fields in your database.

There is much more to SQL injection, but this simple script will help to clean submitted data. It is intended for alphanumeric fields. You can clean numeric fields separately by testing for isNumeric and Not isNull.

Lee has a good deal of experience protecting web sites from SQL injection.

HTML box with rounded corners

Sun, 13 Sep 2008 23:11:31 -0700

This little trick uses the fieldset and legend tags to create a nicely bordered box with a title. It is straight HTML.

Originally this was proprietary to IE, but it has been adapted by Mozilla Firefox. In IE the corners are nicely rounded. In Firefox they are square.

Classic ASP Timer using SQL Server

Wed, 05 Aug 2008 11:04:34 -0700

This script provides a way to cause your Classic ASP page t pause or sleep. It uses SQL Server to perform the sleep function.

Lorem Ipsum Text Filler

Wed, 13 May 2008 23:11:31 -0700

Ever needed something to use as a placeholder for future test? Have you wondered what "Lorem Ipsum� " was all about? Here is 5 paragraphs of Latin gibberish commonly used for text filler.

JavaScript Page Redirection on a Timer

Wed, 26 Feb 2008 19:19:32 -0700

This is a simple but useful JavaScript code snippet which redirects the current page on a timer. Note the timer is in milliseconds.

ASP Break Cache

Sat, 02 Nov 2007 13:43:53 -0700

When you update a data on a data-driven page then redirect a user to it, you want to ensure the web browser displays current content instead of cached content. Use the simple code below to fool the cache.

Random Number Generator

Sat, 02 Nov 2007 13:38:13 -0700

A simple function but very useful. This script will generate a random number between 1 and 1,000,000.

Parse First and Last Names

Fri, 02 Aug 2007 13:46:34 -0700

A simple script I wrote years ago to parse first and last names. It is still handy.

Open CSV File as Dataset

Fri, 02 Aug 2007 11:36:55 -0700

This script shows you how to open a CSV file as a recordset so you can read and write records. It also shows a simple method of looping through the records to print field names and values. The first part of the script opens a CSV file using a direct path to the file. This is the most common method. The commented section shows how to use the ODBC driver for text.

Open MS Access Database and Tables

Fri, 02 Aug 2007 11:32:06 -0700

This script demonstrates how to open a MS Access database using a file path rather than an ODBC dataset name. It also includes sample scripts to open a recordset for writing, open a table as read only, insert a record into a table, delete a record, and update a record.

ASP Timer

Thu, 18 Jul 2007 10:59:30 -0700

This is a simple script to demonstrate how to time an activity in ASP and display the results.

vCard Creator

Sat, 13 Jul 2007 15:44:59 -0700

This script will create a downloadable vCard on the fly. This version uses pre-set parameters, but the name, address, and other information could easily be set from a database.

Modify CSS Property via javaScript

Tue, 12 Feb 2007 09:26:19 -0700

Typically, CSS attributes are represented as properties in a style sheet. They may also be coded directly into an html tag. For example:

some text here

.

But how can you set or change these attributes via JavaScript?

For non hyphenated attributes, the property is identical. So your Javascript could look like this:

onMouseover="this.style.color='#0000ff'"

For hyphenated attributes, drop the hyphen and capitalize the first letter following it. For example: to manipulate the "font-weight" CSS property your JavaScript might look like this:

onMouseover="this.style.fontWeight='#fffff'"

Examples:

color = color
padding = padding
font-weight = fontWeight
background-color = backgroundColor
border-bottom-width = borderBottomWidth

Change CSS Property via javaScript

Tue, 12 Feb 2007 09:26:19 -0700

Typically, CSS attributes are represented as properties in a style sheet. They may also be coded directly into an html tag. For example:

some text here