|
|
Posted by kenoli on 10/20/06 15:06
I asked a question earlier about whether to use one field with a list
of keywords or separate fields with one keyword each in a contact
database. I have been looking around and thinking and it seems like
one field with a list of keywords makes the most sense.
I am going to be working on this this weekend. I wonder if someone on
this list might take the time to help me with a few things related to
this. I'd appreciate any coding suggestions people have for:
1. Getting mutliple keywords from a form via check boxes or pulldown
menus (I plan to get keywords from a lookup table), concatenating them
and inserting them into a keyword field.
2. Adding an additional keyword or more to a keyword field that
already has some keywords in it
3. Searching that field over all records for one or a number of
keywords. (have noticed in some forums that people had trouble making
sure the search looked beyond the first keyword in the list or the
first found record)
4. What kind of separators should I insert between keywords in the
field (e.g. spaces, commas, etc.) and how should I insert them?
5. Anything else anyone with experience thinks I should be4 aware of.
One issue here is that if I used FULLTEXT indexing for this, which
seems like it could be useful, I will run into problems as it will
return nothing if more than 50% of my records have a given key work.
In my situation, more often than not, more than 50% will have the same
keyword. I understand that this limit can be circumvented by using a
boolean search.
I appreciate any help I can get assist my coding efforts this weekend.
Thanks in advance,
--Kenoli
Navigation:
[Reply to this message]
|