Instead of hammering CF with verify cant you use Full Text Searching of Oracle with the "CONTAINS" clause?... I did this 3 years ago on Oracle cant remember the full syntax on Oracle some like
where Contains(ColumnName, 'Hello') Note.. you have to create the full text Catalog before you can use "Contains" Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -----Original Message----- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 10:44 AM 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 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
