Verity Index problem

[srushing]

Hi folks. I am trying to populate a verity collection from a query but having no luck as best I can tell from the searchs that come back null. So I created a collection, and can see it's there using <cfcollection action="list"> And then I setup my query as I need using:

<cfquery datasource="#DS#" name="getAbs">
select * from Abstracts
</cfquery>

and then define a new query with the key field (tmpkey) defined to the path & file name I need:

<cfset qryTmp = querynew("tmpkey,filename,title,author,year,affiliation")>
<cfoutput query="getAbs">
<cfset tmp = queryaddrow(qryTmp)>
<cfset tmp = querysetcell(qryTmp,"tmpkey","e:\web\sctweb\abstracts\" & #year# & "\" & #filename#)>
<cfset tmp = querysetcell(qryTmp,"filename",filename)>
<cfset tmp = querysetcell(qryTmp,"title",title)>
<cfset tmp = querysetcell(qryTmp,"author",author)>
<cfset tmp = querysetcell(qryTmp,"affiliation",affiliation)>
</cfoutput>

If I CFDUMP TMPQRY everything looks great, all the fields just as I want them. The I use CFINDEX to index my query like so:

<cfindex collection="sctabstracts"
query="qryTmp"
action="refresh"
type="file"
key="tmpkey"
>

But after that, I can't seem to return any results when I search. Ideas?

Thanks
S

[Guest]

try action="update"

[srushing]

Thanks Sam, I've tried that as well and havn't had any luck. Refresh is supposed to purge and then update so it seems like it should work but.....

Thanks again though