EXAMPLE OF USER ACTIVATED HELP

This is an example of user activated help implemented in a page.

You need a toggle control like this one to activate/de-activate the help system and the help mode.

Then you need is declare a help ID for every element (here the table headers), then call the onlineHelp custom tag for evey help frame.

You can see an example of static help here

List all column types in "CFExamples" ColdFusion sample Database

<CFX_ODBCInfo DATASOURCE="CFExamples" 
  SELECT="COLUMNTYPES">

TypeName	Precision	LiteralPrefix	LiteralSuffix	Nullable	CaseSensitive	Searchable	Unsigned	Money	AutoIncrement
GUID	36	'	'	YES	NO	UNSEARCHABLE	NO	NO	NO
BIT	1			NO	NO	ALL_EXCEPT_LIKE	NO	NO	NO
BYTE	3			YES	NO	ALL_EXCEPT_LIKE	YES	NO	NO
LONGBINARY	1073741823	0x		YES	NO	UNSEARCHABLE	NO	NO	NO
VARBINARY	255	0x		YES	NO	UNSEARCHABLE	NO	NO	NO

	About the online Help System

This application provides an online help system similar to the online help available in Windows appications.

In any page, click on the help button to activate the system. From now on, every time the mouse is moved over an object for which information is available, the cursor will change for the same icon. Just click on the object to display the information. <

You can move the popup in a more convenient place if you wish. Just drag'n drop the top header.

You can use the system in

Standard mode, or in touring mode.

In standard mode, help windows can be opened by right clicking objects;
In touring mode, all help windows will open as soon as the mouse passes over an object. This mode is recommanded for a first sight of the application, but should normally be deactivated as soon as the system is used for production. In both modes, the system is still functional since the standard left click is not affected.

To shut down the online help system, left click again on the help button.

	Type Name

Data source-dependent data type name; for example, "CHAR", "VARCHAR", "MONEY", "LONG VARBINARY", or "CHAR ( ) FOR BIT DATA". Applications must use this name in CREATE TABLE and ALTER TABLE statements.

	Precision

The maximum precision of the data type on the data source. N/A is returned for data types where precision is not applicable. For more information on precision, see Precision, Scale, Length, and Display Size.

	Literal Prefix

Character or characters used to prefix a literal; for example, a single quote ( ' ) for character data types or 0x for binary data types; An empty string is returned for data types where a literal prefix is not applicable.

	Literal Suffix

Character or characters used to terminate a literal; for example, a single quote ( ' ) for character data types; NULL is returned for data types where a literal suffix is not applicable.

	Nullable

“NO” if the column does not include NULLs. “YES” if the column could include NULLs.

This column returns an empty string if nullability is unknown.

	Case Sensitive

Whether a character data type is case sensitive in collations and comparisons: "YES" if the data type is a character data type and is case sensitive. "NO" if the data type is not a character data type or is not case sensitive.

	Searchable

How the data type is used in a WHERE clause. May be one of the following strings: UNSEARCHABLE if the data type cannot be used in a WHERE clause. LIKE_ONLY if the data type can be used in a WHERE clause only with the LIKE predicate. ALL_EXCEPT_LIKE if the data type can be used in a WHERE clause with all comparison operators except LIKE. SEARCHABLE if the data type can be used in a WHERE clause with any comparison operator. UNKNOWN.

	Unsigned

Whether the data type is unsigned: "YES", "NO" or "N/A".

	Money

Whether the data type is a money data type: "YES", "NO" or "N/A".

	Auto-Increment

Whether the data type is autoincrementing: "YES", "NO" or "N/A". An application can insert values into a column having this attribute, but cannot update the values in the column. Caution: a COUNTER type in Access is not considered as having the AUTOINCREMENT status since it cannot be inserted a value at all.