Wow, thank you. And a big RTFM to myself. ;p I'll check that out.
> 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
>
>
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
