microsoft.public.sqlserver.fulltext
  Home FAQ Contact Sign in
microsoft.public.sqlserver.fulltext only
 
Advanced search
September 2008
motuwethfrsasuw
1234567 36
891011121314 37
15161718192021 38
22232425262728 39
2930      40
2008
 Jan   Feb   Mar   Apr 
 May   Jun   Jul   Aug 
 Sep   Oct   Nov   Dec 
2008 2007 2006  
total
microsoft ... fulltext Profile…
RELATED GROUPS

POPULAR GROUPS

more...

 Up
  @SearchConditions FREETEXTSEARCH CONTAINSTABLE         


Author: Simone Basso
Date: Sep 18, 2008 07:27

I have a situation like this

TAble1
ID Title
UsersCount
1 "the da vinci code"
10
2 "The Da Vinci Code and the Secrets of the Temple" 5
3 "The Da Vinci Code Decoded"
2

I want to have a search that when I search for 'the da vinci code' rank the
results as
1,3,2 because the first book match exactly the phrase while the others have
a density of keywords lower,

I'm trying to do something like this
SET @SearchConditions = 'ISABOUT("the da vinci code" WEIGHT(.9), "the"
WEIGHT(.1), "da" WEIGHT(.1), "vinci" WEIGHT(.1), "code" WEIGHT(.1))';

SELECT * FROM FREETEXTTABLE(xefba_db_Books, Title, @SearchConditions)

but CONTAINSTABLE explode with more than 3 words to weight and FREETEXTTABLE
gives inaccurates results...
Show full article (0.80Kb)
no comments
  Special Characters in Search         


Author: El
Date: Sep 8, 2008 05:32

This has propably been asked before - sorry.

Our Users would like to search for Strings that contain special characters
and I need to figure out a way to do this with SQL Server 2005 full-text
search (example would be 'Job#$23#3'). After searching the net I couldn´t
really come up with a sufficient answer to this demand. It would be great if
you could point me at a resource that explains how to get this done.

Thanks,
El
5 Comments
  commander meridia canada en ligne Achat meridia canada Simple meridia canada sans ordonnance commander comprime de meridia us usa commander meridia canada en ligne         


Author: sdgvfwe
Date: Sep 6, 2008 20:26

commander meridia canada en ligne Achat meridia canada Simple meridia canada sans ordonnance commander comprime de meridia us usa commander meridia canada en ligne
Show full article (2.40Kb)
no comments
  Question about Freetexttable         


Author: geekyguy
Date: Sep 3, 2008 05:33

If I have a FT Index with a varchar field, and there are two rows:

1234
1234AV

If I run a freetexttable query against that index searching for '1234', why
does it only return the first row and not the second? Is there any way to
get it to return both rows, or would I have to use containstable with a
wildcard?

I've been using freetexttable because it works very well when the search
term contains multiple words, but I'm not sure what to do to get it to match
against partial strings like the case above?
4 Comments
  question about freetexttable matching         


Author: geekyguy
Date: Sep 2, 2008 14:24

I have a full text cat for "products" set up against a table with product
information such as product-ID, product-name, product-description, all of
which are in the view. All the fields are varchars.

I have two similar products with similar product-IDs, like:

1234
1234XL

If I perform a freetexttable query against the view, and search for "1234",
only the first product is returned (and if I search for "1234XL" the second
is returned). If I embed "1234" in the product-description for both
products, then both products are returned.

So, it seems like my freetexttable query is looking for an exact string
match...which I guess would make sense. But I'm wondering if there's any way
for it to perform something closer to a "Like" query:

select * from table where product-ID like '%%1234%%' --which would return both
products.

My real query looks like:
Show full article (1.26Kb)
1 Comment
  detektei ses privatdetektiv aachen personenschutz frankfurt detektive frankfurt privatdetektive detektei detektivbuero detektei objektschutz         


Author: sdgvfwe
Date: Sep 2, 2008 05:58

detektei ses privatdetektiv aachen personenschutz frankfurt detektive frankfurt privatdetektive detektei detektivbuero detektei objektschutz
Show full article (2.43Kb)
no comments
  SQL full text catalog problem         


Author: Cipher
Date: Sep 1, 2008 02:59

hello to everyone ,

We have in our company a two nodes active-passive cluster with SQL Server
2000 SP4.
Recently one of our customer required from us to create a full text
catalog for some tables & columns
for his database.
So we made it ,but we realise that Microsoft Search didn't work when we
use a query in order to check it if it works fine.
The service was running and i tried several times a restart of the
service.
For example we made a full text catalog for the table "News" and the
column "newstuff" .

Then we run this query : SELECT newstuff FROM news
contains(prices,'suspeding')
and the answer was nothing ,not error ,not message ..just nothing.

If we run this instead : SELECT newstuff FROM news where newstuff like
'%%suspen%%'
we took as a result hundreds of lines and that is correct.
Show full article (1.28Kb)
no comments
  Need help with sqlserver search stored procedure.         


Author: aboutjav.com
Date: Aug 29, 2008 09:14

HI,

I am writing a stored procedure for my search box control. I found
this sample code which sets the @WORD1 to 'TBB-12' and searches 1
table for the information. I set the value to TBB-12 and specified to
look in the dbo.product_id. It did find the product id = TBB-12 on the
first result row, however, it return a bunch other rows, which none of
the column fields contains the value 'TBB-12'. In theory, a search
should only return 1 row, correct? Why am I getting a bunch extra
useless rows? What is wrong with the sql query?

Thanks,

John

3 * dbo.WordCount('TBB-12', (actress1.fullname + ' '
+actress2.fullname + actress3.fullname + ' ' + actress4.fullname + '
'+ actress5.fullname + ' '+ actress6.fullname + ' '+ actress7.fullname
+ ' '+ actress8.fullname + ' '+ actress9.fullname + ' '+
actress10.fullname)) + dbo.WordCount('TBB-12', dbo.dvd.product_id)

SELECT dbo.dvd.dvdid,
COALESCE(actress1.fullname+',',actress2.fullname+',',actress3.fullname
+',',actress4.fullname+',',actress5.fullname+',',actress6.fullname
+',',actress7.fullname+',',actress8.fullname...
Show full article (3.76Kb)
1 Comment
  using rank in fulltext         


Author: Roy Goldhammer
Date: Aug 28, 2008 00:56

Hello there.

I'm new on FullText Search.

I need this in order to find part of words on 3 of my columns in table
(Table1(Txt1, Txt2, Txt3)

I've discovered the function CONTAINSTABLE(...) which brings me rank of
find.

what is the logical of ranks?
no comments
  hyphen as word-breaker         


Author: Ashish
Date: Aug 20, 2008 10:03

Hello All,

I have a sql server 2005 db which contains a full text catalog on a
table, certain columns on that table have a words with hyphens in them,
the customer expects the results to come up when the search term
contains hyphens, but looks like the indexing service uses hyphens as
word breakers and thus separates them out.

I have tried changing the full text language to neutral on the server
and rebuilding the db but that dint help, is it supposed to behave this
way and is there any configuration changes for this behavior ?

we are using 1033 as the language and using containstable clause to
search in a full text catalog.

thanks
no comments
1 2 3 4 5 6 7 8 9