0 Replies Latest reply on Jul 11, 2006 3:59 PM by vsirota

    Problems with Verity under ColdFusion MX 6.1

    vsirota
      Hi,

      I am having problems with Verity collection under ColdFusion MX 6.1. I do a query and then try to index the results of that query using the CFINDEX tag:

      <cfquery name="qryContent" datasource="#application.datasource#">
      SELECT *
      FROM table
      </cfquery>

      <cfoutput>#qryContent.RecordCount# pages being indexed...<br></cfoutput> ----- here I get 1468 records

      <cfindex
      collection="Main_Content"
      action="refresh"
      type="custom"
      query="qryContent"
      body="cntContent"
      key="pg"
      urlpath="/info.cfm?"
      custom1="content" >

      <cfsearch
      name = "search_results"
      collection = "CoM_Main_Content">
      <cfdump var="#search_results#">
      <cfabort>

      When I do the <CFSEARCH and then <CFDUMP the number of records in the collection is 1409 - hence 59 records less than the query returns...I have deleted the collection numeruos times and re-created it, I have also increased the JVM settings on the ColdFusion server and no difference at all...

      I am out of ideas on how to solve this problem so I am hoping somebody can recommend the solution to this...

      Any ideas would be much appreciated.....

      Thanks,
      Vlad