Fantastic, this is just what I need!
Thanks,
Allen
On 3-Apr-10, at 5:13 AM, Nitai @ Razuna wrote:
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.
--
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 !!
