First, thank you all for your responses. I've taken a deeper look into the problem (and maybe I should have done that before) and found out what my problem is. I'll try to bring it as clear as possible with the following example.
I have my type books and articles and the following hierarchy: nature trees POPLAR OAK (article and book ASSIGNED) flowers ROSE TULIP wildlife fishes SHARK GOLDFISH birds EAGLE (book ASSIGNED) SPARROW (article ASSIGNED)
My article is about oaks and sparrows, so my article is assigned to the keywords OAK and SPARROW. I have a book which is about eagles and oaks, so my book is assigned to the keywords OAK and EAGLE.
In my site I am in the section wildlife, so I only want books from the category and subcategories from wildlife. So my call is the following: <cfa_metadataKeywordObjectFind dataSource = "#request.datasource#" keywords = "OAK,SPARROW" resultSet = "key" lTypeIDs = "#request.TypeIDs.Book#" r_stObjects = "keysBooks" lCategoryIDs = "list of categoryIDs from wildlife" >
When I take a look at the object properties of my book: objectdata stKewords OAK EAGLE lCategories: catID_birds,catID_trees
The tag cfa_metadataKeywordObjectFind searches like: 1. Is the categoryID present 2. Is the keyword present 3. Does the typeID match
If all questions are answered with YES, then the object will be returned. One essential question is missing though: 4. Is the matching keyword member of the provided categories.
This condition is not made in metadataKeywordObjectFind. My book is returned, eventhough it is not about eagles. So before I do a metadataKeywordObjectFind, I have to filter all keywords out which are not present in my categories.
Thanks all and a happy new year, Johan Coens
========= Ing. Johan Coens Allaire Certified ColdFusion Developer <theFactor.e> Friesestraatweg 215a P.o. Box 2010 9704 CA Groningen The Netherlands Tel: +31 (0)50 57 57 888 Fax: +31 (0)50 57 57 889 <http://www.thefactore.com>
Premium Partner for Allaire Cold Fusion Multimedia development with Macromedia Director, Authorware, Flash.
"Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." Albert Einstein =========
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to spectra-talk-request@houseoffusion.com with 'unsubscribe' in the body.
Spectra-Talk
Johan Coens