That's what I was originally looking for. Does 8.0.5 have that? Is it an additional option to install? I can't find anything about it on my server.
> 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 > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
