question about full-text search

Hi all,
I have a single table (TAB_FULL_TEXT_NET) , with only one field indexed
in my sql catalog.
I am runing queries agaist the catalog using CONTAINSTABLE
select [KEY] objDocumento, tf.RANK RANK from
CONTAINSTABLE(TAB_FULL_TEXT_NET, *, '42.55.14.1.2', 300) tf
The problem is that some results returned by the query do not to mach
my search. How can this be possible.
For example i am looking for: 42.55.14.1.2
but some results containing similar words like
42.55.14.2
42.55.14.9.3
42.55.14.6.1
are also returned in the results set
Questions:
1.- Does the CONTAINSTABLE have problems to deal with period '.'
2.- How can I limit my search only to exact words
obs: I have also tried to put the search word into "" (ex:
"42.55.14.1.2") , but same results
Thank you very much
Alberto
Yes, it thinks the . is white space, so your search is done on 42 55 14 1 2.
Matches will be to 42 55 14 1 2 or 42!55!14!1!2, in other words any non
alphanumeric character between the numbers will yield a match.
however, I am unable to repro your problem. Can you tell me what version of
SQL you are running, and the version of the OS, also please issue the
following query and tell me what you get.
select @.@.language.
What word breaker are you using?
Hilary 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
"Gordowey" <albertoiriarte@.gmail.com> wrote in message
news:1132582567.679893.208520@.g14g2000cwa.googlegr oups.com...
> Hi all,
> I have a single table (TAB_FULL_TEXT_NET) , with only one field indexed
> in my sql catalog.
> I am runing queries agaist the catalog using CONTAINSTABLE
> select [KEY] objDocumento, tf.RANK RANK from
> CONTAINSTABLE(TAB_FULL_TEXT_NET, *, '42.55.14.1.2', 300) tf
> The problem is that some results returned by the query do not to mach
> my search. How can this be possible.
> For example i am looking for: 42.55.14.1.2
> but some results containing similar words like
> 42.55.14.2
> 42.55.14.9.3
> 42.55.14.6.1
> are also returned in the results set
> Questions:
> 1.- Does the CONTAINSTABLE have problems to deal with period '.'
> 2.- How can I limit my search only to exact words
> obs: I have also tried to put the search word into "" (ex:
> "42.55.14.1.2") , but same results
> Thank you very much
> Alberto
>
|||Thanks for your quick answer!
well I am using English (USA) as word breaker, but most of the text is
in portuguese ! (is that a problem?)
about the version, see below
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
what do you suggest me to deal with that situation?..
thanks
Alberto
|||Are the documents stored in the image data type column? Are there any html
tags in the content?
Hilary 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
"Gordowey" <albertoiriarte@.gmail.com> wrote in message
news:1132595252.224093.110370@.g49g2000cwa.googlegr oups.com...
> Thanks for your quick answer!
> well I am using English (USA) as word breaker, but most of the text is
> in portuguese ! (is that a problem?)
> about the version, see below
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
> 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
> Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
>
> what do you suggest me to deal with that situation?..
> thanks
> Alberto
>
|||Hi again..
well, I have 2 tables in my catalog
Table 1: one (only text) field indexed
Table 2: One binary field indexed
about html text...not in the text field (table 1), but i am not sure
about Table 2, because users can include html files in the binary
field...
well, any help to deal with the period ('.') would be apreciated...
thanks
Alberto

Question about authentiocation

Hi!

I have SQL Express runing and I'm using basic Authentication (Win 2k3 Web edi.).

But not all my Windows accounts show up in the list. Is this a bug or a setting? I want to add some users but I can't select them.

I'm newbies in microsoft SQL so if someone could help me.

SQL server requires you to add the users that will get permissions to use it. If you use basic authentication it will not use windows authentication but a proprietary way to create and authenticate users.

If you change it to use intergrated security you will need to add and define the permissions for windows users.

If you use intergrated security it usually is easier to define groups and give the group permission.

|||

First of all, thanks for replying.

I used windows authentication. Because I think that's more easy to manage.

But my colleague says they had problems with dbase connection. I don't know what they exactly did, so I have to figure that out, but they are using the SQL auth. at the moment.

I've made a new usergroup called 'SQL'. I added the user 'infostrada' to that usergroup.

By default, everbody is allowed to connect to a win 2003 machine? (policy: access the computer true the network).

So; when using a new user in a new usergroup, do I have to make certain changes inside Windows to let them connect?

í'm first going to check what they changed and try soms things out.

Thanks again.