On 11/13/02 4:11 PM, "David Notik" <[EMAIL PROTECTED]> wrote:
>... > > 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. This is not quite the way Verity works. You create an empty Verity Collection (with CFCOLLECTION). Then you index all your files with Verity (using CFINDEX) (this can be a continuing process, CFINDEX can be called to update or delete entries as needed). When you use CFSEARCH, you tell it which Collection you're searching, you don't pass it filenames. The rest of your description is right, though. You pass a search criteria to CFSEARCH and it will return a Query containing a few pieces of information about each hit. Some of these pieces are customizable and YOU would want the filename as one of those Custom fields (see CFINDEX options). Then you can use the function to pass lists of filenames to a subsequent query to use as a "WHERE filename IN (#quotedValueList(searchQuery.filenameField)# )" clause. > > 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
