[CFCDev] OT: verity question

[Schreck, Thomas (PPC)]

I have an off topic question concerning verity I’m hoping someone can answer.  I’m attempting to create a verity collection for a recordset containing 722 records.  When I do a search against the collection with no criteria, I get 204 records returned.  Is there a size limit to verity collection?  Below is the code I’m using:     <cfquery name="qryProductCatalog" datasource="PPCnet2">             SELECT     tblProdClass.numProdClassID, LOWER(tblProdClass.txtTitle) AS txtTitle, tblProdClass.txtProdClass,                     LOWER(CAST(tblAPCCopy.txtAPCCopy AS varchar(8000))) AS txtAPCCopy, tblInvDiv.txtInvDiv AS txtParentTaxonomy,                     tblProdCategory.txtCategory AS txtTaxonomyName, tblAPCCopy.numDisplayOrder, CAST(tblAPCCopy.numProdClassID AS varchar(50))                     + '_' + tblProdCategory.txtCategory + '_' + CAST(tblTaxonomy.numTaxonomyID AS varchar(50)) AS SiteMapping             FROM         tblProdFamily INNER JOIN                     tblAPCCopy INNER JOIN                     tblProdClass ON tblAPCCopy.numProdClassID = tblProdClass.numProdClassID ON                     tblProdFamily.numProdFamilyID = tblProdClass.numProdFamilyID INNER JOIN                     tblProdCategory INNER JOIN                     tblInvDiv ON tblProdCategory.numInvDivID = tblInvDiv.numInvDivID ON tblProdFamily.numCategoryID = tblProdCategory.numCategoryID INNER JOIN                     tblTaxonomy ON tblInvDiv.txtInvDiv = tblTaxonomy.txtTaxonomyName             WHERE     (tblProdClass.ynIsInternalOnly = 0) AND (tblProdClass.ynIsDiscontinued = 0)             ORDER BY tblProdClass.txtProdClass </cfquery>      <cflock timeout="9000" throwontimeout="No" name="ReIndex" type="EXCLUSIVE">             <cfindex                         action="update"                         collection="ppcCatalogSearch34"                         type="CUSTOM"                         query="qryProductCatalog"                         key="numProdClassID"                         title="txtTitle"                         body="txtTitle,txtProdClass,txtAPCCopy"                         custom1="txtProdClass"                         custom2="SiteMapping"             > </cflock>   <cfsearch collection="ppcCatalogSearch34" name="qrySearchResults">   <cfdump var="#qryProductCatalog#" label="qryProductCatalog">               [RETURNS 722 RECORDS] <cfdump var="#qrySearchResults#" label="qrySearchResults">                 [RETURNS 204 RECORDS]   <cfabort>     Any help or advice would be appreciated.     Thanks -   Tom Schreck 817-252-4900 [EMAIL PROTECTED]   I have not failed.  I've found 10,000 ways that won't work.   - Thomas Edison