[thelist] CF / ODBC Error / Verity

Dear list,

I try to create a verity collection and populate it with the contents of a
database. Now I'm experiencing some problems...

Let's name the collection myCollection. I've created it in the
Administrator, everything's fine.

I populate it with the following:

<!--

<CFQUERY NAME="myquery" DATASOURCE="myDatabase">SELECT * FROM
myTable</CFQUERY>

<CFINDEX COLLECTION="myCollection"
    ACTION="UPDATE" 
    TYPE="CUSTOM"
    TITLE="Field7"
    KEY="IDField"
    BODY=Field1,Field2,Field3,Field4,Field5,Field6,Field7
    QUERY="myquery">

-->

my problems:

1. This seems to index only Field1 and Field7. My use of the "BODY"
attribute might be wrong, documentation on this is very short - at least I didn't
find much more than "enter a comma-delimited list".

2. (really weird) since I've started to experiment with Verity on
myDatabase, I get ODBC timeout errors when I try to access it via CF tags/SQL
(another CGI on the same machine still gets through to the datasource with SQL).
This has been working up to now.

I successfully use Verity to perform full-text search in parts of this
site (same machine). Everything is fine there.

Any ideas? Comments? Suggestions? I'd be most grateful (and
cc:netzdrache@gmx.net would be lovely, as I'm on digest).

kind regards

Sonja

-- 
Sent through Global Message Exchange - http://www.gmx.net