I always give the options in my form
"find all words"
"find exact phrase"
And if this is checked, I loop over the search phrase using SPACE as
delimiter and create a dynamic WHERE clause for each word.
E.G
<cfif isdefined('form.allwords')>
<cfloop list="#form.searchcriteria#" delimiter=" " index="word">
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 issues
Russ,
I am probably a bad SQL coder, but almost all the code that I had to do with
searching structured databases had about 3 times the amount of CF code
interspersed with the SQL queries. Most of the time, my customers want a
single search box which can take all kinds of searches. When they enter a
phrase, then I have to capture the fact that it is a phrase and conduct the
query one way. Now since they want some result, if not for the phrase alone
but its constituents, then I have to separate that out and conduct a
different search. The CONTAINS query in SQL does a lot, especially in terms
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 (albeit anecdotal): When I was working with SQL Server FTS, I was
fine-tuning a search for a client who called about once every 2 days about
some result that she wanted that wasn't being captured by the query when she
entered the search term. Then I would scramble around the code (both SQL and
CFML) trying to make sure that everything would not break and at the same
time, I could accomodate this request. After about 2 months of this, I
switched to Lucene and now? Not a peep out of her! Granted there were some
things I did better the second time round, but I was happy, and so was she.
George
On 10/2/05, Snake <[EMAIL PROTECTED]> wrote:
>
> 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: George Abraham [mailto:[EMAIL PROTECTED]
> Sent: 01 October 2005 14:25
> 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 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 structured databases. At first I tried using the Verity search
> already packaged with CFMX. However I soon ran into scaling issues in
> terms of the number of records that Verity will store. Since one of my
> dbs stores more than 100K records, that alone would take up the limits
> of Verity's licence. Buying an unlimited (or whatever) licence for
> Verity was a bazillion dollars.
> Similar
> problems with buying a Google search appliance. We decided to go with
> Lucene from the Jakarta project which is a simply beautiful product.
> And it is free. Of course you have to learn Java, but the Lucene email
> lists are extremely helpful. Besides Aaron Johnson has some code over
> at (
>
> http://cephas.net/blog/2003/12/06/indexing_database_content_with_lucen
> e_cold
> fusion.html)
> that even talks about CF and Lucene.
>
> I know this doesn't solve your current problem, but I ran into issues
> with SQL server like you did and some of them were having our
> customers (and I, to some extent) tear their hair out.
>
> If you need some help with CF and Lucene, I can list some resources or
> email me offlist.
>
> George
>
>
> On 9/30/05, Martin Parry <[EMAIL PROTECTED]> wrote:
> >
> > 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 no
> results.
> >
> > If I find a solution I'll post it here. IF!
> >
> > Martin Parry
> > http://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 full-text enabled
> > on a table. When I run a query against the full-text index, it
> > returns
> > 31 rows.
> >
> >
> >
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219873
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
