Books Online.
J
-----Original Message-----
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 1:11 PM
To: CF-Talk
Subject: Re: SQL Server and CONTAINS
Update....
I've found that using the FREETEXT clause instead of the CONTAINS clause
will ignore the "ignored" words. Now I need to sort out any possinble
implications of using FREETEXT vs. CONTAINS??
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: Bryan Stevenson
To: CF-Talk
Sent: Friday, November 14, 2003 1:06 PM
Subject: SOT: SQL Server and CONTAINS
Hey All,
I'm using the CONTAINS clause in SQL Server 2000. To do so I had to add a
full-text index on the fileds being searched.
The problem I'm bumping into is the CONTAINS clause seems to be erroring
out
on certain words (i.e. if one of the passed values is my,and.our, etc.).
The error I get is "A clause of the query contained only ignored words."
So obviously it doesn't like these "ignored" words, but what I need to
know
is the whole list of ignored words so I can strip them out of any keyword
searches OR an alternative to CONTAINS (no Verity).
TIA
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
