Database Tables

This section describes database tables used in hyBook, a simple guest book application.

1. "Topic" table will be named as "hyTopic" with the following fields:

ID - "Autonumber" type
Subject - "Text" type
Content - "Memo" type

2. "Comment" table will be named as "hyComment" with the following fields:

ID - "Autonumber" type
TopicID - "Number" type, foreign key pointing to "hyTopic" table.
Content - "Memo" type
Name - "Text" type
Email - "Text" type
Timestamp - "Date" type
IpAddress - "Text" type

Table names are prefixed with "hy" so that they can be merged easily with your existing databases if needed.

Last update: 2006.

Table of Contents

 About This Book

 ASP (Active Server Pages) Introduction

 IIS (Internet Information Services) 5.0

 MS Script Debugger

 VBScript Language

 ASP Built-in Run-time Objects

 ASP Session

 Creating and Managing Cookies

 Managing Sessions with and without Cookies

 scrrun.dll - Scripting Runtime DLL

 Managing Response Header Lines

 Calculation Speed and Response Time

 ADO (ActiveX Data Object) DLL

 Working with MS Access Database

Guest Book Application Example

 Design Overview

Database Tables

 Configuration File

 Page Layout Template File

 Guest book Main Script

 The Utility Script Library File

 Data Submission Issues

 Webmaster Administration Page

 References

 PDF Printing Version