Several of the usual "answerers" (to make up a word) are at OpenCF Summit this week so we'll be sure and look into this as soon as we can.
On Tue, Feb 22, 2011 at 3:07 AM, tom thomas <[email protected]> wrote: > I have been working with this again this morning. Still can not get it to > work. here is my code. > > <cfquery name="qc" datasource="buy"> > select id, title, manufacturer, sku, price, > numberOfReviews, keywords,thumbnailUrl from #qcats.cattable# > </cfquery> > > <cfindex collection= "#qcats.cattable#" action = "update" type= "custom" > body= "id, title, manufacturer, sku, price, numberOfReviews, > keywords,thumbnailUrl " > custom1 = "qc.title" > custom2 = "qc.keywords" > custom3 = "qc.price" > custom4 = "qc.thumbnailUrl" > query= "qc" key= "id"> > > All of the custom fields are repeating the same data. > > Thanks, > Tom Thomas > > > At 08:02 PM 2/21/2011, you wrote: > > I am trying to create a collection / index on a database. I am using code I > found on this site: > http://cflove.org/2010/09/cfcollection-cfindex-and-cfsearch-basic-tutorial.cfmbut > am not getting the results back that I think I should. The code from > that page I am using is as follows. > > <cfcollection action= "Create" collection="MyCollection" path= > "c:\mysite\"> > > <cfquery name="MyQuery" datasource="datasource"> > 2: select pageID, PageText, PageDescription from MyPages > 3: </ cfquery> > 4: <cfindex collection= " MyCollection " action = "update" type= > "custom" body= " PageText,PageDescription " query= " MyQuery " key= "pageID > "> > > I have created and deleted a collection at least a dozen times changing the > code above. Is there something missing in that code to make it work? > > Thanks, > Tom Thomas > > -- > tag/function ref: http://www.openbluedragon.org/manual/ > mailing list - http://groups.google.com/group/openbd?hl=en > > Get to Texas in Feb for OpenCFSummit http://www.opencfsummit.org/ > > -- > tag/function ref: http://www.openbluedragon.org/manual/ > mailing list - http://groups.google.com/group/openbd?hl=en > > Get to Texas in Feb for OpenCFSummit http://www.opencfsummit.org/ > -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- tag/function ref: http://www.openbluedragon.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en Get to Texas in Feb for OpenCFSummit http://www.opencfsummit.org/
