Look up cfindex, you can create a collection from query data and then do your search on that collection using verity.
Douglas Brown Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Tony Schreiber" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 17, 2002 7:44 AM 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
