Ok I have verified the problem I was talking about using a simple test
app. (Code and/or URL available on request.) So what it boils down to is
that keyword searches are unreliable and must be double-checked if you
have the same keyword in multiple categories. :(
While writing my little test app I also found another serious problem. If
you remove all keywords from an object, a keyword search for keywords that
were assigned to that object before they were deleted will still show up
the object. This is because cfa_metadataindexupdate only updates the
verity index with rows that have keywords. (!) So if one remove all
keywords from an object one should do a cfa_metadataindexdelete rather
than a cfa_metadataindexupdate. (hm)
--
Michiel Boland <[EMAIL PROTECTED]>
Digital Valley Internet Professionals
Plantsoen 17, Wageningen, The Netherlands
Phone: +31 317 465555, Fax: +31 317 460276
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
