Unless your Verity collection is indexed from data that never changes, at some point in time you will need to make updates to it. Whether it is to add a new record to the collection or delete one, updating a Verity collection is an important part of keeping your searchable content current.
Adding New Records to a Collection
records can easily be added to an existing Verity collection using
one of two methods. The first method consists of purging the Verity
collection of all records and repopulating it. This is done by
ACTION attribute of the
CFINDEX tag to
method ensures that your Verity collections always contain the most
up-to-date information. The disadvantage to this method is that it
can be relatively time-consuming for larger collections because it
has to completely reindex a collection just to add a single record.
The following syntax shows how to use the
tag to purge and reindex a collection:
<!--- Purge and repopulate a collection using the refresh property of the ACTION attribute ---> <CFQUERY NAME="IndexNews" DATASOURCE="ProgrammingCF"> SELECT ArticleID, Title, Article FROM News </CFQUERY> <CFLOCK NAME="CFINDEX_Lock" TYPE="EXCLUSIVE" TIMEOUT="30"> <CFINDEX COLLECTION="News" ACTION="Refresh" TYPE="Custom" BODY="Title,Article" KEY="ArticleID" TITLE="Title" QUERY="IndexNews"> </CFLOCK>
The second method is to add the new record by appending it to the end
of the collection. This is simple to do using the