I have a problem using category with Verity.

My search form allows people to search in a collection of laws combining
full-text searching and categories filtering (finance, security, youth...).

It is based on a custom collection created from a Database query. The body of
Verity CFINDEX is populated by the text of the law. The category stores an ID
pointing to categories' table of the application.

Everything's OK with CFSEARCH when I set only one value in the category field
of the CFINDEX : I can find texts based on a searched term AND a category.

Of course, as it is a many to many relashionship, I would like to pass
miltiple categories in the category field of CFINDEX as it is presented in CF
documentation. Alas, when I pass a comma delimited list of categories, Verity
cannot find anything :(

Any suggestions ?


This one is OK
<cfindex action="UPDATE" collection="Collection key="ID" type="CUSTOM"
title="Law_Title" query="Get_Content_To_Index" body="Text_of_Law"
category="only_one_category">

This one is not
<cfindex action="UPDATE" collection="Collection key="ID" type="CUSTOM"
title="Law_Title" query="Get_Content_To_Index" body="Text_of_Law"
category="a_comma_separated_lit_of_categories">