RE: [CFCDev] OT: verity question

Andy Ousterhout Wed, 07 Jan 2004 08:53:11 -0800

Just for giggles, change the key to some composite that is unique and see what happens.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Schreck, Thomas (PPC)
Sent: Wednesday, January 07, 2004 9:36 AM
To: [EMAIL PROTECTED]
Subject: RE: [CFCDev] OT: verity question

Yes, my key does have duplicate values, but it is my understanding that Verity does not assume or enforce any rules about uniqueness of values in the Key attribute. The reason I have duplicate key values (a key is the product’s id) is because each product has multiple descriptors I’m pulling in from the database. I’m wanting to have a searchable interface to a product and its descriptors.

Tom

-----Original Message-----
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 9:23 AM
To: [EMAIL PROTECTED]
Subject: RE: [CFCDev] OT: verity question

I am retrieving much larger collections, so my guess is that your 722 records has some duplicates of numProdClassID, your Key.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Schreck, Thomas (PPC)
Sent: Wednesday, January 07, 2004 8:54 AM
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

RE: [CFCDev] OT: verity question

Reply via email to