MACROMEDIA COLDFUSION 4.5-DEVELOPING WEB, Develop Manual

Page: 201 / 380

Chapter 11: Indexing and Searching Data 175
Document fields
The values you specify for the CFINDEX attributes TITLE, KEY, URL, and CUSTOM can
be specified as document fields for use with relational operators in the CRITERIA
attribute. Document fields are referenced in text comparison operators. They are
identified as:
•
CF_TITLE
•
CF_KEY
•
CF_URL
•
CF_CUSTOM1
•
CF_CUSTOM2
For more information on this topic, see the Allaire Knowledge Base article, "Using
Document Fields To Narrow Down Searches" (ID# 1082) on our Web site at
http://
www.allaire.com/Support/KnowledgeBase/SearchForm.cfm .
The SUBSTRING operator
You can use the SUBSTRING operator to match a character string with data stored in a
specified data source. In the following example, a data source called TEST1 contains
the table YearPlaceText, which itself contains three columns: Year, Place, and Text. Year
and Place make up the primary key. The following table shows the TEST1 schema.
ENDS Selects documents by matching the character string you specify
with the ending characters of the values stored in a specific
document field.
SUBSTRING Selects documents by matching the query string you specify with
any portion of the strings in a specific document field. For
example, specifying "god" will match "godliness," "a god among
men," "godforsaken," etc.
YearPlaceText
Year Place Text
1990 Utah Text about Utah 1990
1990 Oregon Text about Oregon 1990
1991 Utah Text about Utah 1991
VerityText Comparison Operators (Continued)
Operator Description