Hi all: I have a document management system. I currently store all my documents with unique file names in one directory. Each document has a record in the database with title, keywords, description, the name of the physical file, and the like. I have simple search functionality. It searches the various database fields described above for the search terms, and displays a list of documents found. I'd like to expand this to search the actual content of the file as well (using Verity), and include the records in the search results documents list. In addition, I only care to search files where, say, I have Active=1 in the database. I have the filename in the database, so I'd imagine I'd pass a list of filenames to search to Verity (CFSEARCH?), and if the search terms are found in the physical files, I'd pass back the filename to the database and get the relevant information from the record to display in the list of documents. Or would I? What's the best way to go about this? Any samples would be appreciated. Thanks in advance. --D ################### David Notik Digital202, LLC Imagination gone digital. Web: <http://www.digital202.com/> www.digital202.com E-mail: <mailto:dave@;digital202.com> [EMAIL PROTECTED] Office: (206) 575-1717 Mobile: (206) 351-3948 ###################
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

