I am a newbie to Cold Fusion, and especially Verity search apps. I'd
like to perform a search on a directory containing files
(.pdf, .doc, .xls, .ppt, etc.). I have an Access database table with
the following fields:
file number (auto generated upon file upload)
file name
date uploaded (auto generated upon file upload)
author
department
file description
keywords
I would like the user to be able to define search criteria for file
name, date, author, department, file description, and keywords. I'd
also like them to have the option of just typing in a keyword and
searching ALL of the fields, including the body of the file. What is
the best way to set this up so the app searches the proper field
and/or body of the file?
I currently have my index as follows:
<!--- Query database to get file names to be Indexed for Search --->
<CFQUERY name="index" datasource="files">
SELECT *
FROM files
</CFQUERY>
<!--- Define parameters of Index action --->
<CFINDEX
collection="cwt"
query="index"
action="REFRESH"
type="custom"
title="name"
key="file_name"
body="keywords, department, other, summary, file_name, name,
date"
custom1="Department"
custom2="number"
extensions=".doc, .txt, .xls, .html, .htm, .cfm, .cfml,
*., .pdf, .ppt">
I know this doesn't work because I am not calling in the body of the
file to be searched, and some of my fields on which I want to
uniquely search, are lumped in with Body.
Any help is greatly appreciated.
Barbara J Smith Consulting
http://www.bjsconsulting.com
[EMAIL PROTECTED]
651.365.0822
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
