[OpenBD] cfcollection and cfindex

[tom thomas]

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/