I am having problems with populating a Verity collection from a query. The
<cfquery name="getCategories" datasource="#application.dsn#">
select category_keyword_id, category_keyword
where category_keyword is not null
The query results are correct, but when the collection is refreshed there are
null category_keyword fields (body) for rows that are correctly populated in
<cfindex action="refresh" collection="SourcesCategories"
key="category_keyword_id" type="custom" title="SourcesCategories"
query="getCategories" body="category_keyword" language="English">
I have purged the collection, refreshed the collection, repaired it and
optimized it. Then deleted it and started over.