Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slacker
Posting Yak Master
115 Posts |
 Posted - 2003-05-26 : 08:38:04
|
| Hi thanks for reading.Im having a problem with the full text search feature. Its giving me an error."Execution of a full-text operation failed. A clause of the query contained only ignored words. Execution of a full-text operation failed. A clause of the query contained only ignored words."Which i understand.. I can handle this error and tell the user to enter a more descriptive search. The problem is.. it does it even if there is good words in there. Heres an example of a contains clause that is failing..CONTAINS(*,'"the" AND "Matrix" AND "Reloaded"')I just noticed.. if i put a * the so its like "the*" then the error goes away.. but i dont want it to work like this...Is this by design or is there a switch i need to set? What am i doing wrong here? Thanks in advance. |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-27 : 19:49:03
|
What does your from clause look like.From BOLquote:
If more than one table is in the FROM clause, * must be qualified by the table name.
also try this if above is okay.CONTAINS(*,' "the" AND "Matrix" AND "Reloaded" ') |
 |
|
|
nizmaylo
Constraint Violating Yak Guru
258 Posts |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-05-27 : 21:40:10
|
| Hi HelenaWelcome back!!!Damian |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-05-28 : 02:43:22
|
| You need to remove noise words before you get to CONTAINS/CONTAINSTABLE. See the link for examples of how to do this on the server side abd client side.[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=23035[/url]HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
|
|
|
FTS and ignored words