> I was wondering if any of you have any thoughts on the > implementation of a 'search-function' on a website. It would > only be a fairly simple input field and some ranked search > results. The website content comes directly from the database btw. > > So far I've used and come up with some scenario's: > > * Simple 'LIKE' clause and a query. Works fairly well, > however ranking is not really an option and PDFs etc are not > searched at all of course. > > * Full-Text search (MS-SQL 2000). Has some cool features, > ranking is great, however only searches on complete words, > complete phrases or words starting with a certain prefix. > Some of the more advanced options such as FORMSOF, NEAR etc, > are not used at all since it's only a simple HTML-input field. > > * Verity: In short: I hate it. I've worked with it in CF5 and > found it to be error-prone, not really maintenance-friendly > and giving crappy results. I haven't used it on CF6, so it > may have improved (please tell me if it has :-) ). I don't > have CF7 (CF6) so the added categorization-functions are not > available btw. > > Now that I think about it, maybe I should give Verity another > shot (especially since it searches the PDFs etc as well).. > But maybe someone else has a better idea?
If you used Verity in CF 5, did you use the K2 engine or the VDK engine? The K2 engine is much better in many respects, and if I recall correctly, CFMX 6.x uses K2 instead of VDK. If you want to search PDFs using SQL Server's full-text functionality, you can do that with a little work: http://www.adobe.com/support/downloads/detail.jsp?ftpID=2611 However, I don't know how well that works with large numbers of PDF documents, since I haven't done it myself. If not for the PDF part, I'd unhesitatingly recommend SQL Server full-text indexing over Verity. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
