 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / November 2005Near parameter
Hello: Somebody knows how much distance between words uses the "NEAR" parameter? PD: Pardon for my English. IIRC its 50 words, after 50 words with a FreeText query the rank drops to 0, after IIRC 1365 words the words are no longer considered to be near.  SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Hello: > > Somebody knows how much distance between words uses the "NEAR" parameter? > > PD: Pardon for my English. Hi Hilary: My query uses "containstable" clause to search with "NEAR" parameter (CONTAINSTABLE(table, field, '"actor" NEAR "gana"'), but not return all records existent. I try with "freetexttable", but return records that not correspond with the query. Any suggestion?. > IIRC its 50 words, after 50 words with a FreeText query the rank drops to > 0, after IIRC 1365 words the words are no longer considered to be near. [quoted text clipped - 4 lines] >> >> PD: Pardon for my English. Vas, Could you post the full output of -- SELECT @@version -- as this is helpful info in understanding your environment. Additionally, is the FT-enabled "table"'s column "field" defined as an IMAGE datatype and contains binary files, such as MS Word or Adobe PDF files? If not, does the text in the "field" column contain any Carriage Returns (CR) or Line Feed (LF) characters? Finally, how many rows are in your FT-enabled "table"? Thanks, John SignatureSQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ > Hi Hilary: > [quoted text clipped - 14 lines] >>> >>> PD: Pardon for my English. Hi John: I will attempt answering to everything with my english, jeje. Number of records: 384.000 Colum type: Image. Colum Content: HTM Documents. I have another colum with extensión of documents (htm) (varchar(3)). My query is: SELECT [KEY] FROM CONTAINSTABLE(ST, Texto, '"actor" near "gana"') The number of result is 50, when really is 72. SELECT @@version: Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) Thanks. > Vas, > Could you post the full output of -- SELECT @@version -- as this is [quoted text clipped - 26 lines] >>>> >>>> PD: Pardon for my English. can you do this query? This will tell you which rows don't show up. Then check the separation distance in these rows select * from (select [key] from containstable(ST, Texto, '"actor" near "gana"')) as X right join (select [key] from containstable(ST, Texto, '"actor" OR "gana"')) as Y on y.[key]=x.[key] where x.[key] is null SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Hi John: > [quoted text clipped - 49 lines] >>>>> >>>>> PD: Pardon for my English. Hi Hilary: This query return all records that not correspond with the condition. Is possible to change the number of words of distance to evaluate?. Thanks. > can you do this query? This will tell you which rows don't show up. Then > check the separation distance in these rows [quoted text clipped - 58 lines] >>>>>> >>>>>> PD: Pardon for my English. No, if the data was stored in the text or char columns I could write something to do this, but not when they are stored in binary. What you need to do is look in these rows returned by the query. Figure out what the word separation or if there is another problem preventing them from showing up in your near searches. Sometimes the angle brackets in html tags prevent words from being indexed. SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Hi Hilary: > [quoted text clipped - 65 lines] >>>>>>> >>>>>>> PD: Pardon for my English. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.