I have a smell web message forum that I wrote several years ago that I'm expanding. It needs a good search feature, for users to search posts. I've tried using SQL to do this, and it tends to be too much for the server, and I'm trying to now create a search tool using Verity.
I've created the collection, and even indexed the data by pulling all posts from the database in a query, and then using that column (plus 'subject') when I do the index. Thing is, when I run cfsearch and pass in a search term, the results I get back, when they come back at all (it times out a lot), there's no "postid" or anything to associate a specific entry with a specific post. The only thing that looks usable is the "key" field, but I don't know how to use it to get to the data I need. What am I doing wrong? :) Thanks! Rob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292813 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
