Working Query (finally!)
SELECT title,
Author,
Publishers,
ListPrice,
ISBN
FROM booksDATA
WHERE MATCH (Title, Author, Publishers)
AGAINST (<cfqueryparam
cfsqltype="cf_sql_varchar"
value="#form.search#">)
If I enter "rabbit potter" (obviously without the quotes) into my search
field, I would expect to see all the "Peter Rabbit" books by Beatrix
Potter, among others. But, I *don't* expect to see "Harry Potter" in the
results, but he's there.
I thought the query had to return results that contained all of the
words entered into the search, not either/or ...
So, how do I be sure the results contain BOTH "potter" and "rabbit",
thusly eliminating "Harry Potter"?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287591
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
