Sixten Otto wrote:
>
> The information that the modification is needed is cleverly concealed
> in a single sentence in the livedocs (and probably also the dead tree
> version); see under "Field Searches":
> http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001327.htm
>
> Then scroll down to the comments for the name of the actual file you
> need to edit, which Macradobe was too coy to reveal. :-\
>
Well, I just don't know how I missed that one. :)
That worked...I did a few tests with the following results....
I created a collection with two word docs in it...each had a single word
in the body ("foo" in doc2 and "blah" in doc1). I then updated doc2 in
the index using:
<cfindex action="UPDATE" collection="testdocs"
key="D:\testdocs\doc2.doc" type="FILE" custom1="jingle santa rudolph">
So now the custom1 field was populated with "jingle santa rudolph".
cf_custom1:`jingle` - Match doc2
cf_custom1:`jingle santa rudolph` - No Match
cf_custom1:'jingle santa rudolph' - Match doc2
cf_custom1:'jingle santa' - Match doc2
cf_custom1:'santa jingle' - No match
cf_custom1:jing - No Match
cf_custom1:jing* - Match doc1
blah cf_custom1:jingle - No match
blah OR cf_custom1:jingle - No Match
foo cf_custom1:jingle - Match doc2
Just to make sure, I did the following searches to make sure the regular
search terms were working as I would expect them to...
foo - Match doc2
blah - Match doc1
foo blah - Match doc1 and doc2
So it looks like the field search will do an exact match of a word or a
phrase and accept a wildcard, but it seems to always act as a logical
AND. So while it is good for filtering results, it's not really usable
to increase the "searchable" text of your collection. I also noted that
the backticks only worked on search terms with no spaces...in order to
filter on a term with spaces, I had to use single quotes.
I'm not sure if this will help anybody...I was hoping it would be a
solution to something I am working on (and possibly to the original
post), but unfortunately I don't think it is.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256656
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
