Webmaster Forum / ColdFusion / Advanced Techniques / January 2007

I did not have any luck posting this under general discussion.  I am hoping
that I will get a nibble under Advanced Techniques.

I am migrating from CF 5 to CFMX 7. Trying to index 9 records from a database
query into a Verity collection. Only the first record in the query ends up in
the Verity index. I know it is the first record from the query, because if I
sort the query results, whatever sorts to the top of the result set is what
shows up in verity.  The code is attached

According to the status variable, I inserted 1 record and updated 0. No errors.

None of the columns in the query result set has a null value in it.

Any idea what I am doing wrong? This same code works fine (without the status
variable) in CF 5.

<CFQUERY NAME="GetArticles" DATASOURCE="#DSN#">
SELECT PAGE_ID, PAGE_TITLE, PAGE_CONTENT
FROM WEBPAGES
order by page_id desc
</CFQUERY>

<CFINDEX
query="GetArticles"
collection="#IndexCollection#"
action="UPDATE"
type="CUSTOM"
key="PAGE_ID"
title="PAGE_TITLE"
body="PAGE_TITLE,PAGE_CONTENT"
status="index_status">