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 |
|
masterslave
Starting Member
22 Posts |
 Posted - 2007-11-27 : 19:29:49
|
| I'm logging error messages for my ASP.NET application with errors being emailed to me as they occur. I continuosly get messages from one of my search pages that uses FTS with "Execution of a full-text operation failed. A clause of the query contained only ignored words". I've taken out all words out of the dictionary file and when use exactly the same search terms (these are emailed to me as well so that's exactly what they type in) and I can't replicate those errors!Having run both sp_configure 'default full-text language' and sp_help_fulltext_columns and the language is 1033 which is English US if I'm not mistaken so it shouldn't be a neutral word breaker... I've blanked all instances noise.eng and noise.enu, replacing all instances with a blank space and yet I'm still getting those errors! This is an example of one of the WHERE clauses where I'm using FTS: AND ( @SearchTermFTS IS NULL OR (CONTAINS(CurrentItem.Description2, @SearchTermFTS) OR CONTAINS(CatalogueItem.CatalogueItemName, @SearchTermFTS) OR CONTAINS(CatalogueItem.CatalogueItemName, @SearchTermFTS)) ) In my ASP.NET code, I'm taking a string of search terms and processing each term to be like @SearchTermFTS = '"penci*" AND "mar*"' Am I doing something wrong? Please help, it's very frustrating!! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-28 : 02:42:40
|
| Does it work in query analyzer? |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-28 : 05:05:14
|
| You shouldn't need the * |
|
|
|
masterslave
Starting Member
22 Posts |
Posted - 2007-11-29 : 21:35:06
|
| Yes, it does work in Query Analyzer!I'm using * as a wildcard, I need that as part of my search... |
|
|
|
|
|
|
FTS Problem