Re: No Verity, no full-text indexing...search options?

2009-04-12 Thread Jason Fisher
Look at Lucene, which you can drop into your codebase and run as your indexing engine. It's an open source Java-based solution. http://lucene.apache.org/ Ray's also got a ColdFusion wrapper for it, called Seeker: http://seeker.riaforge.org/ ~~

Re: No Verity, no full-text indexing...search options?

2009-04-11 Thread Pete Ruckelshaus
It's unworkable because I need to notify support of every table and column that needs to be text-indexable, and I haven't gotten confirmation that they support auto-updating. I have a problem with being reliant upon support for something that could possibly go south and usually try to avoid the s

Re: No Verity, no full-text indexing...search options?

2009-04-11 Thread James Holmes
Why is it unworkable? Do you not have permissions to do so? It's the best solution to this problem if the content is in the DB. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/4/12 Pete Ruckelshaus : > > the process for enabling full-text indexing on MS SQL S

Re: No Verity, no full-text indexing...search options?

2009-04-11 Thread C. Hatton Humphrey
> Apart from a simple SQL "where [column] like '%[phrase]%' " clause, are > there any other options out there?  I also don't want to use a custom Google > search, for a variety of reasons. You might make use of a dictionary web service like http://services.aonaware.com/DictService/DictService.asm

No Verity, no full-text indexing...search options?

2009-04-11 Thread Pete Ruckelshaus
I'm using a pretty bare-bones CF host for a content-managed site. It's got CF8 and I'm using MS SQL Server; however, they don't support the creation of Verity collections (why, I don't know...) and the process for enabling full-text indexing on MS SQL Server is unworkable (so, CONTAINS() is out).