Question on this process: 1.Create the collection on the ColdFusion Administrator Verity page. 2.Execute a query and output the data. 3.Populate the collection using the CFINDEX tag.
Why do I need to OUTPUT to data if I'm just going to use CFINDEX on the query? That's a lot of data I have to have to output it somewhere. It that part really necessary? > 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 > > > ______________________________________________________________________ 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
