example #2

Example 2 Product Entry Form

HTML Support includes:

	single entry text boxes
	scrolling text boxes
	check boxes
	radio buttons
	drop down menu

Usage of pwPage Example 2 Product Entry Form

The table definition, as show below the example form, has defined Item Name and Part Number 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 2 Product Entry Form

Status	Current Model	Prior Year Model
Stocking Type	Stock Inventory	Order As Required
*Item Name*
*Part Number*
Category
Description
Quantity On Hand
Stocking Level
Unit Price
Time Stamp

Example 2 mySQL Table Create Statements

CREATE TABLE example2 (
rowid BIGINT NOT NULL AUTO_INCREMENT,
rbStatus CHAR(8) NOT NULL,
cbStock CHAR(4) NOT NULL,
cbOrder CHAR(4) NOT NULL,
itemName CHAR(40) NOT NULL,
partNumber CHAR(40) NOT NULL,
category CHAR(40) NOT NULL,
description VARCHAR(240) NOT NULL,
quantityOnHand INT NOT NULL,
stockingLevel INT NOT NULL,
unitPrice DECIMAL(10,2) NOT NULL,
lastUpdate TIMESTAMP,
PRIMARY KEY (ItemName, partNumber),
KEY secondaryKey (rowid)
)

	The "example2Review" 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 #2 review ]

Last modified: September 10, 2000