Question about Proximity (NEARness) with Full Text Indexing on SQL Server 7

Hello group,
Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR? Is this
setting adjustable? Is is stored in the registry? INI or config file?
I'm using SQL Server 7 SP3.
Thanks,
Kelly Greer
KellyGreer1@.nospam.com
replace nospam with yahoo
Its hardcoded. I believe after 50 words the rank drops off to 0. I also
believe that after 1366 (or some large number of words like that) you will
no longer get a hit.
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
"kellygreer1" <kellygreer1@.yahoo.com> wrote in message
news:1122912214.203288.58290@.g47g2000cwa.googlegro ups.com...
> Hello group,
> Does anyone know how near a word needs to be to another word to be
> included in the results of a CONTAINS search that uses NEAR? Is this
> setting adjustable? Is is stored in the registry? INI or config file?
> I'm using SQL Server 7 SP3.
> Thanks,
> Kelly Greer
> KellyGreer1@.nospam.com
> replace nospam with yahoo
>
|||Kelly,
Q. Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR?
A. Within 50 non-noise words. Additionally, end-of-sentence and
end-of-paragraph also have an effect on the "nearness" of one word or phrase
to another word or phrase.
Q. Is this setting adjustable?
A. No. This is hard-coded.
Q. Is it stored in the registry? INI or config file?
A. No and No. Although, I would hope in some future SQL Server version
(post-SQL Server 2005) that this would be possible, IMHO.
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"kellygreer1" <kellygreer1@.yahoo.com> wrote in message
news:1122912214.203288.58290@.g47g2000cwa.googlegro ups.com...
> Hello group,
> Does anyone know how near a word needs to be to another word to be
> included in the results of a CONTAINS search that uses NEAR? Is this
> setting adjustable? Is is stored in the registry? INI or config file?
> I'm using SQL Server 7 SP3.
> Thanks,
> Kelly Greer
> KellyGreer1@.nospam.com
> replace nospam with yahoo
>

Question about Proximity (NEARness) with Full Text Indexing on SQL Server 7

Hello group,

Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR? Is this
setting adjustable? Is is stored in the registry? INI or config file?

I'm using SQL Server 7 SP3.

Thanks,
Kelly Greer
KellyGreer1@.nospam.com
replace nospam with yahooIts hardcoded. I believe after 50 words the rank drops off to 0. I also
believe that after 1366 (or some large number of words like that) you will
no longer get a hit.

--
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
"kellygreer1" <kellygreer1@.yahoo.com> wrote in message
news:1122912214.203288.58290@.g47g2000cwa.googlegro ups.com...
> Hello group,
> Does anyone know how near a word needs to be to another word to be
> included in the results of a CONTAINS search that uses NEAR? Is this
> setting adjustable? Is is stored in the registry? INI or config file?
> I'm using SQL Server 7 SP3.
> Thanks,
> Kelly Greer
> KellyGreer1@.nospam.com
> replace nospam with yahoo|||Kelly,
Q. Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR?
A. Within 50 non-noise words. Additionally, end-of-sentence and
end-of-paragraph also have an effect on the "nearness" of one word or phrase
to another word or phrase.

Q. Is this setting adjustable?
A. No. This is hard-coded.

Q. Is it stored in the registry? INI or config file?
A. No and No. Although, I would hope in some future SQL Server version
(post-SQL Server 2005) that this would be possible, IMHO.

Regards,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

"kellygreer1" <kellygreer1@.yahoo.com> wrote in message
news:1122912214.203288.58290@.g47g2000cwa.googlegro ups.com...
> Hello group,
> Does anyone know how near a word needs to be to another word to be
> included in the results of a CONTAINS search that uses NEAR? Is this
> setting adjustable? Is is stored in the registry? INI or config file?
> I'm using SQL Server 7 SP3.
> Thanks,
> Kelly Greer
> KellyGreer1@.nospam.com
> replace nospam with yahoo

Question about FullText Search

Hi eveyone,

I have a fullText catalog for a very simple table with 3 rows which contains text like below:

Row 1==> First term, Second term 4-3/16" third term 14.75 forth term 998 3-3/8" 8911 8
Row 2==> First term, Second term 5-3/16" third term 14.95 forth term 11
Row 3==> First term, Second terms 2/18" third term 14.07 forth term 3-3/8" 3

When I try to run query:

1. Select * from myFullText where contains(Text, '3/16') return row 1 and 2 ( ok )
2. Select * from myFullText where contains(Text, '11-3/8') ==> return row 2 (matching 11 only)
3. Select * from myFullText where contains(Text, '3-3/8') return no record
4. Select * from myFullText where contains(Text, '3/8') return no record

If someone do understand about Microsoft FullText search, please help me by explain to me why the output for sql #2, 3 and 4 are like that.

Regards,

John Dang

FYI,

Currently I am using SqlServer 2005, english language and Window XP Pro OS.

JDang

|||

Workaround:

Add more keywords:

3-3/8 + 3/8 + 3-3 + 3 + 338 ...

Consider to eliminate slashes and dashes

Make sure that noisewords do not disdurb. ( I dont know enough about when they are used )

Thomas Boffo

Question about FullText Search

Hi eveyone,

I have a fullText catalog for a very simple table with 3 rows which contains text like below:

Row 1==> First term, Second term 4-3/16" third term 14.75 forth term 998 3-3/8" 8911 8
Row 2==> First term, Second term 5-3/16" third term 14.95 forth term 11
Row 3==> First term, Second terms 2/18" third term 14.07 forth term 3-3/8" 3

When I try to run query:

1. Select * from myFullText where contains(Text, '3/16') return row 1 and 2 ( ok )
2. Select * from myFullText where contains(Text, '11-3/8') ==> return row 2 (matching 11 only)
3. Select * from myFullText where contains(Text, '3-3/8') return no record
4. Select * from myFullText where contains(Text, '3/8') return no record

If someone do understand about Microsoft FullText search, please help me by explain to me why the output for sql #2, 3 and 4 are like that.

Regards,

John Dang

FYI,

Currently I am using SqlServer 2005, english language and Window XP Pro OS.

JDang

|||

Workaround:

Add more keywords:

3-3/8 + 3/8 + 3-3 + 3 + 338 ...

Consider to eliminate slashes and dashes

Make sure that noisewords do not disdurb. ( I dont know enough about when they are used )

Thomas Boffo

Question about Full Text Searching

Hi,

I was wondering when is it worth using Full Text Searching as opposed to using LIKE? Also, since I will be using third party for hosting my site, generally, do hosts support Full Text Searching?

Thanks!Sorry to be vague but it depends on how much data you'll be searching...and if you want to use other features such as EnglishQuery.

Question about datetime

Hi,
I have a table in SQL Server 2000, a field StatDate datatype datatime, 8 all
null true
If the user do not enter a date in the text box it is returning a error type
mismatch ever though the field is set to allow Nulls.
What can I do to correct this
Thanks
DibCan you post the datetime format you are using while inserting the data?
Anith|||Check the code that generates an insert from the empty
text box. My guess: the insert is trying to put the empty
string '' into a datetime column. The empty string is not
a valid datetime string.
Steve Kass
Drew University
Dib wrote:

>Hi,
>I have a table in SQL Server 2000, a field StatDate datatype datatime, 8 al
l
>null true
>If the user do not enter a date in the text box it is returning a error typ
e
>mismatch ever though the field is set to allow Nulls.
>What can I do to correct this
>Thanks
>Dib
>
>|||There is no format, however when the form loads if the field is blank I am
inserting "" empty string to the textbox,
if you think this is the problem how can I correct it, When in Debug Mode
the textbox is an "" empty string.
Thanks
Dib
"Steve Kass" <skass@.drew.edu> wrote in message
news:uCEVMAMKFHA.2728@.TK2MSFTNGP10.phx.gbl...
> Check the code that generates an insert from the empty
> text box. My guess: the insert is trying to put the empty
> string '' into a datetime column. The empty string is not
> a valid datetime string.
> Steve Kass
> Drew University
> Dib wrote:
>
all
type|||I don't know. If there is a newsgroup specific to the particular front
end you are using to create this form and connect it with the database,
that might be a better place to ask. If you want a SQL Server solution,
the best I can suggest is to insert into a varchar-type column in a
staging table or use an instead of trigger to capture the form
information and generate an insert after turning '' into NULL. But
neither of these is as good a solution finding a way to create the
correct insert statement. I would expect most front-end programs to
have some kind of control that corresponds more directly to SQL Server
datetime than just a string/text control.
SK
Dib wrote:

>There is no format, however when the form loads if the field is blank I am
>inserting "" empty string to the textbox,
>if you think this is the problem how can I correct it, When in Debug Mode
>the textbox is an "" empty string.
>Thanks
>Dib
>"Steve Kass" <skass@.drew.edu> wrote in message
>news:uCEVMAMKFHA.2728@.TK2MSFTNGP10.phx.gbl...
>
>all
>
>type
>
>
>|||Thanks
Dib
"Steve Kass" <skass@.drew.edu> wrote in message
news:ePzRSXMKFHA.2764@.tk2msftngp13.phx.gbl...
> I don't know. If there is a newsgroup specific to the particular front
> end you are using to create this form and connect it with the database,
> that might be a better place to ask. If you want a SQL Server solution,
> the best I can suggest is to insert into a varchar-type column in a
> staging table or use an instead of trigger to capture the form
> information and generate an insert after turning '' into NULL. But
> neither of these is as good a solution finding a way to create the
> correct insert statement. I would expect most front-end programs to
> have some kind of control that corresponds more directly to SQL Server
> datetime than just a string/text control.
> SK
> Dib wrote:
>
am
8|||You cannot insert "" into a datefield. What I usually do is create a stored
procedure to do the insert with input variables defined that have a default
value of Null. Then from the form, I only send those fields which have a
value. The insert statment in the SP will then give the value of Null to any
variables not sent and insert a Null value into the table for that field.
If you don't want to use an SP, have the form specifically send Null as the
value for the field.
"Dib" wrote:

> Hi,
> I have a table in SQL Server 2000, a field StatDate datatype datatime, 8 a
ll
> null true
> If the user do not enter a date in the text box it is returning a error ty
pe
> mismatch ever though the field is set to allow Nulls.
> What can I do to correct this
> Thanks
> Dib
>
>