RE: [CFCDev] OT: verity question

Wed, 07 Jan 2004 08:34:28 -0800

Thanks for the reply.  I removed the <cflock> and no luck. I also changed from update to refresh and no luck either.  I’ve deleted, renamed, purged collection and no lovin’.  I’m stumped.

 

 

-----Original Message-----
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 07, 2004 9:21 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [CFCDev] OT: verity question

 

From livedocs:

 

update: updates a collection and adds key to the index. Do not use the cflock tag with this option.

 

Not sure why not, but the answer might be somewhere here:

 

 

Ade

-----Original Message-----
From: Schreck, Thomas (PPC) [mailto:[EMAIL PROTECTED]
Sent: 07 January 2004 14:54
To: [EMAIL PROTECTED]
Subject: [CFCDev] OT: verity question

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=""

                        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

 

Reply via email to