metadata retrieval problems

Hello all, How can you tell which children belong to which parent? If you do a cfa_contentobjectget it returns (amongst other things)a structure called stKeywords.  However, this returns you a list of metadata, it does not tell you which keywords belong to which parent and you cannot access the second part of the struct (there is no documentation I've found which details how it is setup). e.g. Below is stKeywords from a contentobjectget I ran: ACCOUNTING F53A1A05-31FA-11D5-97FE0080C8F5FAE5   FIRST ACCOUNTS F53A19AB-31FA-11D5-97FE0080C8F5FAE5   LCATEGORIES F53A19AB-31FA-11D5-97FE0080C8F5FAE5,F53A19B0-31FA-11D5-97FE0080C8F5FAE5,F53A 1A05-31FA-11D5-97FE0080C8F5FAE5,F53A19B5-31FA-11D5-97FE0080C8F5FAE5,F53A1A0A -31FA-11D5-97FE0080C8F5FAE5,F53A1A0F-31FA-11D5-97FE0080C8F5FAE5,F53A1A17-31F A-11D5-97FE0080C8F5FAE5   V2X0 F53A19B0-31FA-11D5-97FE0080C8F5FAE5   V2X0X1 F53A19B5-31FA-11D5-97FE0080C8F5FAE5   V3X0 F53A1A0A-31FA-11D5-97FE0080C8F5FAE5   V3X0X1 F53A1A0F-31FA-11D5-97FE0080C8F5FAE5   V4X0 F53A1A17-31FA-11D5-97FE0080C8F5FAE5   I cannot tell which Vxxx belongs to Accouting and which belongs to First Accounts.  I think that if you look at the first perhaps 5 digits of the ID it groups them for you, however: a) How do you access the IDs b) Is it always the first 5 numbers that you should use to try to find its parent. If anyone has a solution I would be most grateful, thank you! Karling. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

I find your email a bit confusing - it seems like your asking, "What is the stKeywords structure exactly?" It is a structure of keywords where the value of each keyword represents the UUID of the category it came from. If a keyword has been assigned from multiple categories, the value will be a list. There is also a special key, lCategories, which is a lsit of all the categories. Ok, for the sake of discussion, let's pretend category IDs are strings. Imagine an object Foo. It has the keyword StarWars assigned to it from the category Movies. So, stKeywords would look like this: stKeywords   Starwars =  Movies   LCategories = Movies Now, lets add one more keyword, StarTrek, also from movies. stKeywords   Starwars =  Movies   StarTrek =  Movies   lCategories = Movies Now lets add Football, from AmericanSports stKeywords   Starwars =  Movies   StarTrek =  Movies   Football = AmericanSports   lCategories = Movies, AmericanSports Now lets add Football, from EuroSports, since Football is already a keyword, we just append to the list of cats associated with it. stKeywords   Starwars =  Movies   StarTrek =  Movies   Football = AmericanSports, EuroSpots   lCategories = Movies, AmericanSports, EuroSports Therefore, you CAN tell where a keyword was assigned from. Does that help? ======================================================================= Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email   : jedimaster@macromedia.com ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda ----- Excess quoted text cut - see Original Post for more ----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

Hello, retrieving the actual data and matching it to its parent when you don't know which it belongs to was my problem.  However I am trying to overcome that by matching each child's stparent to its parent in the stkeyword list. The problem I have now is that, if the stkeywords label contains a space, it cannot be resolved and its corresponding id found. eg: ACCOUNTING F53A1A05-31FA-11D5-97FE0080C8F5FAE5   FIRST ACCOUNTS F53A19AB-31FA-11D5-97FE0080C8F5FAE5   LCATEGORIES F53A19AB-31FA-11D5-97FE0080C8F5FAE5,F53A19B0-31FA-11D5-97FE0080C8F5FAE5 Then it cannot retrieve First Accounts because there is a space there.  If I search for FirstAccounts, First%20Accounts, [First Accounts] all to no avail.  Is there an unwritten rule that a keyword cannot contain a space? Thanks! Karling. I find your email a bit confusing - it seems like your asking, "What is the stKeywords structure exactly?" It is a structure of keywords where the value of each keyword represents the UUID of the category it came from. If a keyword has been assigned from multiple categories, the value will be a list. There is also a special key, lCategories, which is a lsit of all the categories. Ok, for the sake of discussion, let's pretend category IDs are strings. Imagine an object Foo. It has the keyword StarWars assigned to it from the category Movies. So, stKeywords would look like this: stKeywords   Starwars =  Movies   LCategories = Movies Now, lets add one more keyword, StarTrek, also from movies. stKeywords   Starwars =  Movies   StarTrek =  Movies   lCategories = Movies Now lets add Football, from AmericanSports stKeywords   Starwars =  Movies   StarTrek =  Movies   Football = AmericanSports   lCategories = Movies, AmericanSports Now lets add Football, from EuroSports, since Football is already a keyword, we just append to the list of cats associated with it. stKeywords   Starwars =  Movies   StarTrek =  Movies   Football = AmericanSports, EuroSpots   lCategories = Movies, AmericanSports, EuroSports Therefore, you CAN tell where a keyword was assigned from. Does that help? ======================================================================= Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email   : jedimaster@macromedia.com ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda ----- Excess quoted text cut - see Original Post for more ----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm