example #1

Example 1 Name and Address Form

Key Benefits

	No configuration required other than for a symbolic link
	Instantly available once the data base table and HTML page are created
	Review output can be tailored with a simple HTML change
	Review output automatically ordered in primary key sequence
	Review output can be selected for easy updates
	Consistent, intuitive interface
	Written in ANSI C for speed with availability of source code
	Available for the popular mySQL data base
	Can be tailored to most popular data bases

Usage of pwPage Example 1 Name and Address Form

The table definition, as show below the example form, has defined Name and Company as the primary key.

Review: Using entirely blank values for these keys will retrieve all table values when using the Review function. Which fields are output is defined by use of the hidden review field and associated values. Any rowid of any resulting output from use of the Review function can be clicked, which will select the associated table row for subsequent processing. Any portion of the leftmost part of key values can be entered for Review retrieval as pwPage will wildcard the remaining portion.

Select: pwPage table row selection requires entry of the fully qualified key(s) for unique table rows. Assuming the row key(s) were entered properly and that the row does exist, normal response should be a fully populated form with current row contents.

Insert: pwPage expects and requires that each table row be defined with unique keys hence inserting duplicate fully qualified key entries will/should fail. Using pwPage against a table containing non-unique rows would compromise the integrity of pwPage processing logic and is not supported.

Update: Enter the fully qualified key for the row to be updated. Although prior selection is not required, you will typically use either the Select or Review function to select the row to be updated to insure that row contents are what you expect them to be prior to making changes with the Update function. The Update function will automatically retrieve the updated table row with the Select function as a means of confirmation of updated row contents. Normal response should be a fully populated form with current row contents.

Delete: Enter the fully qualified key for the row to be updated. Although prior selection is not required, you will typically use either the Select or Review function to select the row to be deleted to insure that row contents are what you expect them to be prior to deletion. The Delete function will automatically "attempt" to retrieve the deleted table row with the Select function as a means of confirmation that the deleted row no longer exists. Normal response should be a blank form.

Example 1 Name and Address Form

Select the items that apply, and then let us know how to contact you.

Send product literature
Send company literature
Have a salesperson contact me

*Name*
Title
*Company*
Address
Email
Phone
Time Stamp

Example 1 mySQL Table Create Statements:

CREATE TABLE example1 (
rowid BIGINT NOT NULL AUTO_INCREMENT,
cbProduct CHAR(4) NOT NULL,
cbCompany CHAR(4) NOT NULL,
cbContact CHAR(4) NOT NULL,
name CHAR(40) NOT NULL,
title CHAR(40) NOT NULL,
company CHAR(40) NOT NULL,
address VARCHAR(240) NOT NULL,
email VARCHAR(100) NOT NULL,
phone CHAR(20) NOT NULL,
lastUpdate TIMESTAMP,
PRIMARY KEY (name, company),
KEY secondaryKey (rowid)
)

	The "example1Review" HTML form is normally only used for Review results. The direct link provided on these pages are merely for convenience so that you can see the "raw" form prior to being populated by review processing.
	The "error" link is also provided to show the "raw" form prior to being populated by pwPage error processing.

[ Home ] [ Up ] [ example #1 review ]

Last modified: September 10, 2000