Empress Software 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

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