User Guide

Table Of Contents
PART IV
Accessing and Using Data
This part describes how to access and use sources of data, including SQL (Structured Query
Language) databases, LDAP (Lightweight Directory Access Protocol) directories, and Verity
document collections. It provides an introduction to the SQL language, describes how to query
and update SQL data sources, and how to use record sets and the ColdFusion query of queries
mechanism to manipulate record sets. It also describes how to access and use LDAP directories,
and how to index and search collections of documents and data sources using the Verity search
engine.
The following chapters are included:
Chapter 19: Introduction to Databases and SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 447
Chapter 20: Accessing and Retrieving Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 465
Chapter 21: Updating Your Database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 475
Chapter 22: Using Query of Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 489
Chapter 23: Managing LDAP Directories . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 515
Chapter 24: Building a Search Interface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 547
Chapter 25: Using Verity Search Expressions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 581
PART IV