HELP CFINDEX

[Wes98765]

I have never used cfindex before but I have a site that uses it. I had to reload cfadministrator onto a new server and transfer all the webs.

CODE:
<CFQUERY NAME=OBJECTS DATASOURCE=&quot;#SITENAME#&quot;>
SELECT
OBJECTS.OID,
OBJECTS.SID,
OBJECTS.TYPE,
OBJECTS.TITLE,
OBJECTS.TEXT,
OBJECTS.LINK,
SECTIONS.SID,
SECTIONS.SHORT_NAME,
SECTIONS.LONG_NAME

FROM
OBJECTS,
SECTIONS

WHERE
OBJECTS.SID = SECTIONS.SID
AND
OBJECTS.TYPE <> 'L'
</CFQUERY>
returns 200+ recs
<!---INDEX---->
<CFINDEX COLLECTION=&quot;#SITENAME#&quot;
ACTION=&quot;Update&quot;
TYPE=&quot;Custom&quot;
TITLE=&quot;TITLE&quot;
KEY=&quot;OID&quot;
BODY=&quot;TITLE,TEXT,TYPE,SHORT_NAME,LONG_NAME&quot;
QUERY=&quot;OBJECTS&quot;>

ERROR:
Error occurred in tag CFINDEX

Collection name not found


The error occurred while processing an element with a general identifier of (CFINDEX), occupying document position (18:2) to (24:17).

Thanks for any help on this

Wes

 

[ecobb]

You will need to create a collection under &quot;Mappings&quot; in the CF Administrator.

Hope This Helps!

Ecobb

&quot;Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer.&quot; - Homer Simpson

 

[Wes98765]

Hey Ecobb,
I created a collection in coldfusion administrator and now I get the error:

Error occurred in tag CFINDEX

Key query column not found


The error occurred while processing an element with a general identifier of (CFINDEX), occupying document position (18:2) to (24:17).

 

[Wes98765]

Is there something else I need to do in the administrator to make this work? The code has to be fine since it worked before the web transfer.

Wes

 

[ecobb]

Hmmm, not sure about that one. If you have a verity collection and a mapping set up, you may want to check and make sure that the collection and mapping are named the same in the code as they are on the server. I'm really not sure where to go after that, we may have to look at some code to figure out what it's looking for on the server.



Hope This Helps!

Ecobb

&quot;Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer.&quot; - Homer Simpson

 

[Wes98765]

Hey I fixed it, thanks for all your help. I don't know what I did lol. I uploaded changes and same error then I put in a output to test some variables uploaded it then it worked? Oh well as long as it works : P

Thanks

Wes