re: Curious problem with CFINDEX
You have to create 2 different collections, one for the 1 document and the other for the 5 database rows and then create a 3rd collection that merges the first two, iirc. From: Kevin Parker tras...@internode.on.net Sent: Monday, November 01, 2010 9:11 PM To: cf-talk cf-talk@houseoffusion.com Subject: Curious problem with CFINDEX Be grateful for some insight if anyone can help please. Have a CFINDEX script (FILE) that when run on its own against the test site correctly indexes 1 document. Have a CFINDEX script (CUSTOM) that when run on its own against the test database correctly indexes 5 rows. But when I run both together (on the same cfm template) the result is not 6. If I run the document one first and then the database one there are 5 records in the collection. If I run the database one first and then the document one there is only one record in the collection. The template commences with a PURGE and I've tried using both UPDATE and REFRESH but same result. TIA!!! ++ Kevin Parker m: 0418 815 527 ++ http://au.linkedin.com/in/krparker ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338743 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Curious problem with CFINDEX
That is what I was going to say also, but I'm not sure if this is the case, it has been a long time since I used cfindex as I have always found it has no speed benefit over database queries, but If you check the cfdocs they seem to imply that you can index multiple types in the same collection with an update. The implication could be wrong though, they may simply be using the same collection name in all the code examples. Russ -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 02 November 2010 11:42 To: cf-talk Subject: re: Curious problem with CFINDEX You have to create 2 different collections, one for the 1 document and the other for the 5 database rows and then create a 3rd collection that merges the first two, iirc. From: Kevin Parker tras...@internode.on.net Sent: Monday, November 01, 2010 9:11 PM To: cf-talk cf-talk@houseoffusion.com Subject: Curious problem with CFINDEX Be grateful for some insight if anyone can help please. Have a CFINDEX script (FILE) that when run on its own against the test site correctly indexes 1 document. Have a CFINDEX script (CUSTOM) that when run on its own against the test database correctly indexes 5 rows. But when I run both together (on the same cfm template) the result is not 6. If I run the document one first and then the database one there are 5 records in the collection. If I run the database one first and then the document one there is only one record in the collection. The template commences with a PURGE and I've tried using both UPDATE and REFRESH but same result. TIA!!! ++ Kevin Parker m: 0418 815 527 ++ http://au.linkedin.com/in/krparker ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Curious problem with CFINDEX
Ah, you may be right, Ross. It's been a long time since I've done the multi-Verity thing, too, but maybe it's possible to UPDATE with 2 collections? Rings a (rather dim) bell ... From: Russ Michaels r...@michaels.me.uk Sent: Tuesday, November 02, 2010 7:52 AM To: cf-talk cf-talk@houseoffusion.com Subject: RE: Curious problem with CFINDEX That is what I was going to say also, but I'm not sure if this is the case, it has been a long time since I used cfindex as I have always found it has no speed benefit over database queries, but If you check the cfdocs they seem to imply that you can index multiple types in the same collection with an update. The implication could be wrong though, they may simply be using the same collection name in all the code examples. Russ -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: 02 November 2010 11:42 To: cf-talk Subject: re: Curious problem with CFINDEX You have to create 2 different collections, one for the 1 document and the other for the 5 database rows and then create a 3rd collection that merges the first two, iirc. From: Kevin Parker tras...@internode.on.net Sent: Monday, November 01, 2010 9:11 PM To: cf-talk cf-talk@houseoffusion.com Subject: Curious problem with CFINDEX Be grateful for some insight if anyone can help please. Have a CFINDEX script (FILE) that when run on its own against the test site correctly indexes 1 document. Have a CFINDEX script (CUSTOM) that when run on its own against the test database correctly indexes 5 rows. But when I run both together (on the same cfm template) the result is not 6. If I run the document one first and then the database one there are 5 records in the collection. If I run the database one first and then the document one there is only one record in the collection. The template commences with a PURGE and I've tried using both UPDATE and REFRESH but same result. TIA!!! ++ Kevin Parker m: 0418 815 527 ++ http://au.linkedin.com/in/krparker ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
