You can use verity to index databasecontent in CF. Make a query that contains the data you want to index and use <cfindex type"custom">. Look in the studio help under "Developing ColdFusion Applications -> Indexing and Searching Data -> Indexing Query Results"
-----Original Message----- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: woensdag 17 juli 2002 16:44 To: CF-Talk Subject: Text Searching Options I'm in need of some full text searching of one or two fields within my database. I'm currently using Oracle 8.0.5 and I can't find anything about full text searching... I can't use Verity because I'm trying to search within database columns, not files. The goal is to optimize the search for products in our database either by the name of the product or its extended description. Right now, I use a simple LIKE sql expression (with ANDs for multiple keywords) that can take quite a bit too long. There's something interesting that phpBB does which is to create a psuedo index of keywords and their related topics: topicid keyword 1 foo 2 foo 1 bar 3 bar 4 fee 4 fi 4 fo Then the search looks in that table on which the keyword column can be indexed and no LIKE is needed, though for substring searches you're back to using LIKE again. Any other ideas? Or comments on the psuedo index idea? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___________The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com ______________DigitA Camera Scripts and Tips http://www.linklabexchange.com _____________Miata Link ECU Data Exchange ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
