Hi all,
I am having some problems with the indexing of Verity collections.
I am trying to index an SQL query from an Access database. Its a simple
query where I selected the ID, Name from a table. The collection has been
defined in CFAdmin and I updated the collection as below:
<cfindex action="update" collection="Names" key="customer_ID" type="CUSTOM"
title="CustomerName" query="getNames" body="customername"
language="English">
Afterwhich I tried searching for records containing the word "frank". There
were at least 4 "frank"s in the whole database but it kept giving me only 3
of them.
I have tried recreating the collection but it still left out the last
"frank". Is there anyway I can see what Verity has indexed? I displayed the
query results directly and the results seemed to be correct.
Thanks
David
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
