Working on a search for a site that's 100% database driven. Not sure I'm going to be able to use Verity on it, so looking at other methods.
I believe I have a view worked out in the database that I can query and generate the proper URLs to get where needed. But, the client has now thrown in a slight monkey wrench - he wants the search form to "suggest" stuff when you start typing. Using cfinput auto-suggest isn't too much trouble, but there's going to be a *TON* of data being searched and I'm not sure how to handle that. You simply can't return every piece of text, minus common words, from the database as a list of any type to "suggest". Or can you? How are others handling this sort of thing? __________ Information from ESET NOD32 Antivirus, version of virus signature database 5130 (20100519) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333826 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm