Colin Riley's Database Info Page

SQL

Notes on creating a table in MYSQL and inserting data into it.

SQLite

Graphical User Interfaces for SQLite Databases

A basic introduction SQLite SQL as well as using it under Microsoft Windows

Select queries with single tables and using the WHERE clause

Creating calculated fields in SQL queries

SQL SELECT queries using two or more tables as well as using Dot Notation for Table-Column Names.

INNER and OUTER JOIN QUERIES and using the GROUP BY clause.

Using the Attach statement in SQLite to create a database and copying a table from the main database to an attached database.

Odd notes on SQLite

Data Entry Automation

Create Data Entry Form from SQL a Create table statement Data entered into the form is compiled and use to generate insert Statements for SQL database.

DDE for 5250 Sessions - Use Microsoft Access to write to an AS400 Terminal Emulator Session.

Javascript application to Enter Data into a web form in Internet Explorer-From comma delimited text.

Javascript Syntax Notes and Examples

Javascript syntax and examples

Creating and accessing an array object in Javascript

Testing for page elements and dealing with strings.

Javascript Program Examples

innerhtmlexample.htm - Javascript program that uses innerHTML and an javascript array to change the text in a web page

JavascriptDatabase.htm - Simple Client side Javascript Database program.

parsebyspace.htm - Javascript program to parse text delimited by spaces or tabs and re-delimit using a user specified character

reviewchar.htm - Javascript program Examines each character in a section of text and list ASCI code."

airportcodedb.htm - Javascript database using a delimited text file as data source.

Unit of Measurement Conversions-Javascript Calculators to convert units of measurement. Some common, Some obscure.