Index of SQLITE Syntax

• Aggregate Function example
• Aggregate Functions
• Add a field to an Existing Table
• Alter table, Rename or Remove Table Columns
• Attach Database
• Calculations in SQL Queries
• Concatenate Strings
• Copy tables
• CREATE TABLE
• Datatypes in SQLite
• Delete a table.
• Delete records from a table
• Dot Commands
• Dot Notation for Table-Column Names
• Drop columns from a table
• DROP TABLE
• GROUP BY
• Import text files .import command
• INSERT Statement
• Joins, Query
• Left Outer Join Query
• ORDER BY Clause
• Outer Join Query
• Rename a Table
• Rename table example
• Rename table columns
• REPLACE string function
• ROUND function example, floating point numbers
• Show Tables .tables dot command
• SQLite Database Browser
• SQLite Manager
• SQLite Tutorial start
• Starting SQLite in Microsoft Windows
• String Manipulation Functions
• SUBSTR Function
• TRIM white space from a string
• Update tables
• Windows, Microsoft

Index of
Javascript Syntax and
Code Examples

• Alert Dialog Box
• Array
• Associative Array
• Commenting Javascript Code
• Conditional Statements
• Dialog Boxes
• Do While Loop
• The Document Object
• For In Loop
• If and If then else Statements
• Iframe, referencing forms elements from the parent document
• innerHTML
• Input - Prompt Dialog Box
• Loading Javascript from a .js file
• Loop Statements
• Math Functions
• Math Object Properties
• Hyperlinks, Triggering Javascript to run
• On Change Event
• Page Elements, Testing for
• parseFloat function
• parseInt() function
• Passing Values between functions
• Placing Javascript in a webpage
• Rounding Numbers
• String Manipulation
• String Variables, Changing text case
• Switch Conditional Statement
• substr method
• substring method
• toFixed Method
• toLower
• toString() Method
• toUpper
• Variables, Declaring
• While Loop
• Writing to a webpage using innerHTML

Hosted by www.Geocities.ws