| Web HTML Toolkit Application Developers Guide Empress Hypermedia v8.62 May 2006
--- | ---

  © 1983, 2006 Empress Software Inc.

  All rights reserved. Reproduction of this document in whole or part, by electronic or any other means, is prohibited without written consent from Empress Software Inc.

  RESTRICTED RIGHTS LEGEND

  Use, duplication, or disclosure by the Government is subject to restrictions as set forth in
  subparagraph (c) (1) (ii) of the Rights in Technical Data and Computer Software clause at 52.227-7013.

  05/06

  Part #: 001-06-H1-110

  This manual provides general guidelines for invoking the toolkit CGI utilities and as reference guide for Internet/Browser application developers.

  ## Table of Contents

  ### CHAPTER 1: Overview

  | 1.1 | Introduction
  | 1.2 | Scope of Use
  | 1.3 | Toolkit CGI Program

  ### CHAPTER 2: Setting Up Toolkit Applications

  | 2.1 | Introduction
  | 2.2 | Components of the Toolkit Applications
  | 2.3 | How Toolkit Works ?
  | 2.4 | Connection to the Database
  | 2.5 | Resource Variables
  | 2.6 | Example

  ### CHAPTER 3: Variables in Toolkit Applications

  | 3.1 | Introduction
  | 3.2 | Query Results
  | 3.3 | User Input - Form Variables
  | 3.4 | Form values in SQL
  | 3.5 | URL Line Parameters
  | 3.6 | Environment and Resource Variables
  | 3.7 | Language-Specific Applications

  ### CHAPTER 4: ehsql:writer

  | 4.1 | Introduction
  | 4.2 | Invoking ehsql:writer
  | 4.3 | Query Database
  | 4.4 | Execute Tag and It's Types

  |  | 4.4.1 | SQL
  |  | 4.4.2 | TRANSACTION
  |  | 4.4.3 | COMMIT
  |  | 4.4.4 | EDIT
  |  | 4.4.5 | WRITER
  |  | 4.4.6 | EH_INFO
  |  | 4.4.7 | EH_INFO_EDIT
  |  | 4.4.8 | SCRIPT
  |  | 4.4.9 | SYSTEM
  |  | 4.4.10 | CONTENT-TYPE
  |  | 4.4.11 | EMPVERS
  |  | 4.4.12 | INCLUDE

  ### CHAPTER 5: ehsql:select

  | 5.1 | Introduction
  | 5.2 | Invoking ehsql:select from a HTML Form
  | 5.3 | The Contents of a Select Form
  | 5.4 | The Output of a Select Form
  | 5.5 | The Select Form Variables

  ### CHAPTER 6: ehsql:update

  | 6.1 | Introduction
  | 6.2 | Invoking ehsql:update from a HTML Form
  | 6.3 | Record Editing Form
  | 6.4 | The Update Form Variables
  | 6.5 | Examples

  |  | 6.5.1 | Inserting with Automatic Key Updating
  |  | 6.5.2 | An Update Application

  ### CHAPTER 7: Bulk and Text Data

  | 7.1 | Insert Binary Files
  | 7.2 | Display Binary Attributes

  ### CHAPTER 8: Session-based Application

  | 8.1 | Introduction
  | 8.2 | Creating Log-on Form
  | 8.3 | Transaction Control
  | 8.4 | Shutting Down the Connection

  ### CHAPTER 9: Errors and Messages

  | 9.1 | Introduction
  | 9.2 | User Formatted Error Reports
  | 9.3 | Suppressing Particular Connectivity Server Errors
  | 9.4 | Log Files
  | 9.5 | Tracing SQL Commands

  ### CHAPTER 10: Security Features

  | 10.1 | Introduction
  | 10.2 | HTTP Access Control
  | 10.3 | HTML Application Scope
  | 10.4 | Empress Connectivity Server Access Control
  | 10.5 | Empress Database Access Control
  | 10.6 | Example

  ### APPENDIX A: CGI Environment Variables

  ### APPENDIX B: Toolkit Enhancement