Welcome, I was in the same boat some years ago :-) Actually it is very easy. First you need to create a collection (cfcollection) and then you index your query (add the search results to the collection)
<cfquery name="myquery"...> select id, col1, col2 from xxx </cfquery> <cfindex collection="mycollection" query="myquery" <cfindex action="update" query="myquery" collection="1" key="id" body="id,col1,col2"> (you can get fancy and add a category and categorytree to the index as well) Then simply issue a search with cfsearch like: <cfsearch collection="1" criteria="searchcriteria" name="result"> <cfdump var="#result#"> Now for the searchcriteria you can get into very elaborate stuff. I have made a overview for my Razuna customers and you are free to look it up at http://wiki.razuna.com/display/ecp/Search+and+Find+Assets Hope this helps and yes, Oracle has a powerful search especially with index and alike, but ou will find the Lucene search engine a equal component. Kind Regards, Nitai On Sat, Apr 3, 2010 at 1:37 PM, Slugbait <[email protected]> wrote: > I was wondering if there were any tutorials or howto's specific to > OpenBD for using <cfsearch> and such. I am a complete newbie when it > comes to searching, having come from Oracle where I can use function > based indexes and a handy LIKE '%WHATEVER%'. I've never really had to > do much in the way of searching. > > There are discussions about cfsearch in this group, but at this hour > I'm just not comprehending them very well. :) > > I essentially just need to be able to search for words within two > columns in one database table. -- See for yourself how easy it is to manage files today. Join the revolution! Razuna SaaS On-Demand - Hosted Digital Asset Management Solution http://www.razuna.com/ Razuna - Open Source Digital Asset Management http://www.razuna.org/ Follow us on Twitter http://twitter.com/razunahq -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !! To unsubscribe, reply using "remove me" as the subject.
