MACROMEDIA COLDFUSION MX 61-DEVELOPING COLDFUSION MX, Develop Manual

Page: 554 / 860

554 Chapter 25: Using Verity Search Expressions
You can specify the values for the
cfindex
attributes TITLE, KEY, URL, and CUSTOM as
document fields for use with relational operators in the
criteria
attribute. (The SCORE and
SUMMARY attributes are automatically returned by a
cfsearch
; these attributes are different for
each record of a collection as the search criteria changes.) Text comparison operators can reference
the following document fields:
•
cf_title
•
cf_key
•
cf_url
•
cf_custom1
•
cf_custom2
To explore how to use document fields to refine a search, consider the following database table,
named Calls. This table has four fields and three records, as the following table shows:
A Verity search for the word certain returns three records. However, you can use the document
fields to restrict your search; for example, a search to retrieve H problems with the word
certain in the problem description.
These are the requirements to run this procedure:
•
Create and populate the Calls table in a database of your choice
•
Create a collection named Training (you can do this in CFML or in the ColdFusion MX
Administrator).
The following table shows the relationship between the database column and
cfindex
attribute:
You begin by selecting all data in a query:
<cfquery name = "Calls" datasource = "MyDSN">
Select * from Calls
</cfquery>
call_ID Problem_Description Short_Description Product
1 Can't bold text properly
under certain conditions Bold Problem H
2 Certain optional attributes
are acting as required
attributes Attributes Problem ColdFusion
3 Can’t do a File/Open in
certain cases File Open Problem H
Database column
The cfindex
attribute Comment
call_ID key The primary key of a database table is often a key
attribute.
Problem_Description body This column is the information to be indexed.
Short_Description title A short description is conceptually equivalent to a title,
as in a running title of a journal article.
Product custom1 This field refines the search.