Need some Verity advice here... I created a search feature for a Project/Task/Time tracking application. I created 5 collections, 4 of which are populated using data selected from a distinct view and 1 that is populated using a file search.
My question is this. I can do "pinpoint" searches (e.g., I added the word "abracadabra" into one of the task notes and the search found it with no problems), but when I do broader searches (for something like "Priority" or other nebulous words that are peppered through the names, notes and entries), it returns only a few of the possible matches. The biggest collection has 80,000 records in it and the smallest has around 1,000... right now I'm using the following for my results: <cfsearch collection="#form.searches#" name="results" type="SIMPLE" criteria="#lcase(form.searchfor)#"> Any ideas? C. Hatton Humphrey, Developer Fisher, Towne & Associates 716-839-2141 x336 [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists