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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292814 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
