<cfquery name="qc" datasource="buy">
</cfquery>
<cfindex collection= "#qcats.cattable#" action = "" 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.cfm but am not getting the results back that I think I should. The code from that page I am using is as follows.--
<cfcollection action= "" collection="MyCollection" path= "c:\mysite\">
<cfquery name="MyQuery" datasource="datasource">
2: select pageID, PageText, PageDescription from MyPages
3: </ cfquery>
4: <cfindex collection= " MyCollection " action = "" 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/
