Verity Indexing Problems

[Anne Girardeau]

I'm trying to use the Verity search engine in CFMX 6.1 and I can't seem to get the system to create a collection from a query.  Here's the code:

<cfquery name="getContent" datasource="#request.siteDSN#">
SELECT Keywords.KeyID, Keywords.Keyword, Keywords.Title, Copy.Copy, ViewType.ViewType, AppType.AppType
FROM Copy INNER JOIN ((AppType INNER JOIN Keywords ON AppType.AppID = Keywords.AppID) INNER JOIN ViewType ON Keywords.ViewID = ViewType.ViewID) ON Copy.KeywordID = Keywords.KeyID
</cfquery>

<cflock name="indexCollection" timeout="120">
<cfindex collection="siteContent"
action=""> type="Custom"
body="Copy, Keyword"
key="KeyID"
title="Title"
query="getContent">
</cflock>

I've tried doing this with both the standard Verity engine and Verity K2 to no avail.  Any ideas as to what I may be doing wrong?

Thanks,
--Anne

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---