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_lucene_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:219839 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54