SQL Server 2005
For the life of me, I cannot figure out why the hell this...
WHERE
CONTAINS (EventName,' my NEAR chemical NEAR romance ')
...returns 0 results, yet this...
WHERE
CONTAINS (EventName,' chemical NEAR romance ')
...returns the correct records.
Why does my exclude
Are there any results that actually have those 3 words near each other ?
Russ
-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com]
Sent: 23 November 2010 18:01
To: cf-talk
Subject: (ot) SQL Server Full-Text Search CONTAINS()
SQL Server 2005
For the life of me, I
Ayep. The band name is My Chemical Romance. I'd say that definitely
qualifies as NEAR. :-)
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
I'm not overly familiar with NEAR but most of the examples I've seen where
NEAR is strung together show it without the quotes.
CONTAINS (EventName,'my NEAR chemical NEAR romance')
That's probably no help, but I thought I'd share.
On Tue, Nov 23, 2010 at 1:00 PM, Matt Quackenbush
@ Michael-
Unfortunately, you are correct: That's no help. Same result without the
quotes. :-(
I know that noise words are ignored, but what appears to be happening is
that it is ignoring the entire thing, rather than just the (possible) noise
word my.
: (ot) SQL Server Full-Text Search CONTAINS()
I'm not overly familiar with NEAR but most of the examples I've seen where
NEAR is strung together show it without the quotes.
CONTAINS (EventName,'my NEAR chemical NEAR romance')
That's probably no help, but I thought I'd share.
On Tue, Nov 23, 2010
Thanks for the tip on using just a single NEAR keyword. In this particular
example (my chemical romance), it still results in no records being
returned. The only thing I can figure is that 'my' is a noise word, and all
searching is ignored once a noise word is hit.
For the time being, I've
Matt,
I googled on sql server noise words and found this link:
http://arcanecode.com/2008/05/29/creating-and-customizing-noise-words-in-sql-server-2005-full-text-search/
I followed the directions and found the noise lookup file being used by SQL
Server 2005 on my computer, and confirmed
Carl,
Thanks for that link. I appreciate it. :-)
I guess I am simply totally misunderstanding noise/stop words in SQL
Server. My understanding was that they were ignored in a query. But the
behavior I am seeing indicates that the entire search string is ignored if
such a word is
I now recall having this issue myself many years ago, and the reason it
doesn't work is because the noise words (now called stop words) are not
actually indexed, rather than being stripped from the search which is what
you assumed. On SQL 2000 you couldn't even use the stop words period or you
Just an off-the-wall idea.
Did you try a different order to the words? I.E. chemical NEAR romance
AND my
I was speculating what might happen of the 'noise' word came later in
the list.
~|
Order the Adobe Coldfusion
@ Russ-
Thanks for the reply. I've read that page so many times that it's all just
gibberish right now. My brain is mush. LOL
Suffice it to say, as you stated, when encountered in a FTS search string,
noise/stop words block any results from being delivered.
@ Ian-
I had not tried that
-
From: Matt Quackenbush [mailto:quackfu...@gmail.com]
Sent: 23 November 2010 22:07
To: cf-talk
Subject: Re: (ot) SQL Server Full-Text Search CONTAINS()
@ Russ-
Thanks for the reply. I've read that page so many times that it's all just
gibberish right now. My brain is mush. LOL
Suffice
Russ,
You did, of course, state why, but it did not click until you just reworded
it. Thank you! It makes perfect sense now.
(And yes, I had already changed to removing noise words from the search
string.)
~|
Order the
Paul,
SUBSTRING(URLdescription,PATINDEX('#Searchstring#',URLdescription),256)
That worked perfectly. I had never used the PATINDEX command before so I
overlooked it completely.
A little massaging of the search string to make it a wildcard matching
pattern and all is well. Thank you.
Dennis
On 7/1/2010 2:21 AM, UXB Internet wrote:
That worked perfectly. I had never used the PATINDEX command before so I
overlooked it completely.
books-on-line is your best friend when it comes to sql server.
~|
Order the Adobe
I on a project we are using the SQL 200X internal Full Text catalog to
search the database and it is finding the correct data just fine. However,
the client would like me to pull a summary of the data that matched the text
search out of the database. Just the summary of the section of the data
On 6/30/2010 5:50 AM, UXB Internet wrote:
How would I pull just the 256 byte section of the ntext field URLdescription
that matches the searchstring?
one way might be to use PATINDEX SUBSTRING (see sql server books-on-line for
details).
Ok, I know I am not the first to want to do this but for the life of me I
can not find any useful CF examples of what I would like to do.
I have switched a high traffic website (CF5.X) from Verity to MSSQL's Full
text search (FREETEXTTABLE). It works but as expected the results are not
as good
Hello all,
After the full-text search index process concludes, aren't your like
queries supposed to be *faster*?
Surely I've done nothing wrong :-)... I've created a full text index on
my tblReceipts table with 800K records, which took SQL Server 2000 about
6 hours to complete. I selected
Hi,
After the full-text search index process concludes, aren't your like
queries supposed to be *faster*?
Surely I've done nothing wrong :-)... I've created a full text index on
my tblReceipts table with 800K records, which took SQL Server 2000 about
6 hours to complete. I selected two
, 2006 2:40 PM
To: CF-Talk
Subject: OT: SQL Server Full-Text Search issue
Hi,
After the full-text search index process concludes, aren't your like
queries supposed to be *faster*?
Surely I've done nothing wrong :-)... I've created a full text index on
my tblReceipts table with 800K records, which
a problem with MS
Clusters only.
Martin
http://www.beetrootstreet.com
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 02:18
To: CF-Talk
Subject: RE: SQL Server 2000 Full-text search issues
Martin,
That's the weird thing with ours. I assumed the same
Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 02:18
To: CF-Talk
Subject: RE: SQL Server 2000 Full-text search issues
Martin,
That's the weird thing with ours. I assumed the same thing that it was
the install. So, we scheduled down time for the production box
of focussed results. But when it does not work for us when we want any old
result that remotely has to do anything with the entered search term. I
might be talking through my hat here, but I searched long and hard for
answers to my problems with full-text search in SQL Server. A simple
statistic
AND column contains '#word#'
/cfloop
cfelseif isdefined('form.exactPhrase')
AND column contains '#form.searchCriteria#'
/cfif
--
Russ
-Original Message-
From: George Abraham [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 14:02
To: CF-Talk
Subject: Re: SQL Server 2000 Full-text search
What sor tof problems.
I have used FULL-TEXT SEARCH many times without problem, even on a massive
13gb database with millions of records, it certainly never required the user
to do anything special, they just entered their search query in the form as
uusal.
russ
-Original Message-
From
October 2005 15:26
To: CF-Talk
Subject: RE: SQL Server 2000 Full-text search issues
What sor tof problems.
I have used FULL-TEXT SEARCH many times without problem, even on a
massive
13gb database with millions of records, it certainly never required the
user
to do anything special, they just
: Fri 9/30/2005 11:41 AM
To: CF-Talk
Subject: RE: SQL Server 2000 Full-text search issues
I too get this on my 2003 cluster. I restored the database as a backup
from my dev box (which it works on) and do a full rebuild - It takes but
a second to say its complete and then gives me absolutely
From: Martin Parry [mailto:[EMAIL PROTECTED]
Sent: Sun 10/2/2005 11:08 AM
To: CF-Talk
Subject: RE: SQL Server 2000 Full-text search issues
I don't have problems on my dev box but when uploading the DB to live
server it never populates the catalogue. I think it's something
Hi,
Full-text search on SQL Server 2K gave me huge problems. Not only was the
code to conduct a full-text search cumbersome, but the user had to learn how
to define searches in ways that were not really fair to the user. That is
why I decided to turn to another appliance for full-text search
: George Abraham [mailto:[EMAIL PROTECTED]
Sent: Saturday, 1 October 2005 11:25 PM
To: CF-Talk
Subject: Re: SQL Server 2000 Full-text search issues
Hi,
Full-text search on SQL Server 2K gave me huge problems. Not
only was the code to conduct a full-text search cumbersome,
but the user had
I have a development CF server (Windows 2003 Server, SQL Server 2000 SP4, CFMX
6.1) on which I have a database that has full-text enabled on a table. When I
run a query against the full-text index, it returns 31 rows.
I have 2 production servers. 1 production CF Server (Windows 2003 Server,
-Server-L.asp
Matt Osbun
Applications Manager
Health Systems, International
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Friday, September 30, 2005 10:22 AM
To: CF-Talk
Subject: SOT: SQL Server 2000 Full-text search issues
I'm at my wit's end on this one and don't
://www.beetrootstreet.com
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: 30 September 2005 16:22
To: CF-Talk
Subject: SOT: SQL Server 2000 Full-text search issues
I have a development CF server (Windows 2003 Server, SQL Server 2000
SP4, CFMX 6.1) on which I have a database that has
Does anyone know if it is possible to use cfqueryparam to bind a string to an
MS SQL full-text search column?
Here's what I'm trying:
cfquery name=VARIABLES.qrySomeQuery datasource=#REQUEST.DataSource#
SELECT *
FROMSomeTable
WHERE CONTAINS(SomeColumn_varchar, 'FORMSOF
if it is possible to use cfqueryparam to
bind a string to an MS SQL full-text search column?
Here's what I'm trying:
cfquery name=VARIABLES.qrySomeQuery
datasource=#REQUEST.DataSource#
SELECT *
FROMSomeTable
WHERE CONTAINS(SomeColumn_varchar, 'FORMSOF
(INFLECTIONAL
James Reily wrote:
cfquery name=VARIABLES.qrySomeQuery datasource=#REQUEST.DataSource#
SELECT *
FROMSomeTable
WHERE CONTAINS(SomeColumn_varchar, 'FORMSOF (INFLECTIONAL,
cfqueryparam cfsqltype=cf_sql_varchar value=#VARIABLES.SomeString# )')
/cfquery
I get back the
Removing the quotes worked!
Thanks guys!
-James
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message:
Good Day List,
I'm looking for a custom tag or some other examples of programing to take
advantage of full-text search(both CONTAINS and FREETEXT) from within
ColdFusion... Can anyone help???
There seems to be a daunting number if permutations that can blowup the
search string.
Sincerely
Folks:
I need to be able to search our entire web server and find specific strings
in .cfm, .html and .cgi files. I have attempted to user Verity to
accomplish this, but Verity doesn't appear to index ALL of the ASCII data in
a .cfm file. (e.g. Doesn't appear to be a Full-Text search.)
Can
to user Verity to
accomplish this, but Verity doesn't appear to index ALL of the ASCII data
in
a .cfm file. (e.g. Doesn't appear to be a Full-Text search.)
Can anyone suggest an efficient method to search the entire ASCII contents
of a given list of .cfm, .html and .cgi files?
In a nutshell, I need
: Full-Text Search w/ Verity? (Not Working!)
If you have Cold Fusion Studio or HomeSite you can use the Search functions
there to accomplish this.
Chuck Rodgers
At 12:22 PM 1/22/02 -0500, you wrote:
Folks:
I need to be able to search our entire web server and find specific strings
in .cfm, .html
hi...
i have setup a full text search and have been searching happily...
but not getting errors if i search for 2 words
how can i change this:
WHERE CONTAINS(r.*, '#search#%')
to do and OR search.
something like ??
WHERE CONTAINS(r.*, '
cfloop index=newsearch list=#search# delimiters
: full text search
hi...
i have setup a full text search and have been searching happily...
but not getting errors if i search for 2 words
how can i change this:
WHERE CONTAINS(r.*, '#search#%')
to do and OR search.
something like ??
WHERE CONTAINS(r.*, '
cfloop index
To: CF-Talk
Subject: Re: [Oracle Full text search]
yes. intermedia it's on the oracle CD
[EMAIL PROTECTED] wrote:
Does Oracle have any full text search facility? I can't find any mention of
it anywhere
yes. intermedia it's on the oracle CD
[EMAIL PROTECTED] wrote:
Does Oracle have any full text search facility? I can't find any mention
of
it anywhere.
just as a completely OT FYI of some mild interest, ms, oracle, ibm
all got their word breaker (for text indexing) software from the same
yes. intermedia it's on the oracle CD
[EMAIL PROTECTED] wrote:
Does Oracle have any full text search facility? I can't find any mention of
it anywhere.
**
The opinions expressed in this E-mail are those
Does Oracle have any full text search facility? I can't find any mention of
it anywhere.
**
The opinions expressed in this E-mail are those of the individual and
not necessarily the company. This E-mail
Other than converting to Lauren* Closet and searching for Lauren*
Closet, how do I automagically search and find: Lauren's Closet using
SQL7 full text search?
best, paul
~~
Structure your ColdFusion code with Fusebox. Get the official book
Other than converting to Lauren* Closet and searching for Lauren*
Closet, how do I automagically search and find: Lauren's
Closet using
SQL7 full text search?
Escape single quotes by replacing them with two single quotes prior to
submitting the search query. You would then be searching
Thanks! That's what I tried first. Didn't work. Now it does. Go figure.
best, paul
At 03:39 PM 6/5/01 -0500, you wrote:
Other than converting to Lauren* Closet and searching for Lauren*
Closet, how do I automagically search and find: Lauren's
Closet using
SQL7 full text search
Has someone experince the SQL full text search mechanisem
with ColdFusion? Is it possible to send regular FullText Queries
(i.e CONTAINS and FREETEXT code) and display results
EFFICIENTLY? or should I use some other method (for displaying,
not searching - SQL Full Text is the mechanisem I want
* Team Allaire *
Has someone experince the SQL full text search mechanisem
with ColdFusion? Is it possible to send regular FullText Queries
yes. do it all the time.
(i.e CONTAINS and FREETEXT code) and display results
EFFICIENTLY
* Team Allaire *
Has someone experince the SQL full text search mechanisem
with ColdFusion? Is it possible to send regular FullText Queries
yes. do it all the time.
That's great to hear! are you simply using CFQUERY
I use M$ full-text quite a bit. But I don't understand your question.
best, paul
At 02:06 PM 5/16/01 +0200, you wrote:
Has someone experince the SQL full text search mechanisem
with ColdFusion? Is it possible to send regular FullText Queries
(i.e CONTAINS and FREETEXT code) and display results
* Team Allaire *
I haven't decided yet on which SQL version to use : 7 or 2000 (any major
diffrence?,
because money is an issue...)
sql server 2000's full text has quite a few nice improvements. we can't even
buy new sql server 7 here.
* Team Allaire *
CFQUERY datasource=xx name=xx
SELECT colum1,colum2
CONTAINS .
AND.
WHERE
/CFQUERY
CFQUERY datasource=xx name=xx
SELECT colum1,colum2
WHERE CONTAINS(*,'wheat beer') AND
58 matches
Mail list logo