Although database management systems now allow you to insert binary objects into your database, this is not their intended use and are, therefore, not very good at this!
VERY simple solution. Store your resumes in a safe place off of the root of your web server and index them using Verity (CFINDEX) and search the documents using CFSEARCH. Verity is a purpose built text retrival engine and, although not the full (and very expensive) version that you can purchase commercially, does its job very well. Doing this will make it a heck of a lot easier to retrieve your documents that if you have to drag them out of SQL Server and its scalable! Stephen ----- Original Message ----- From: "Vishal Narayan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, October 02, 2002 9:48 AM Subject: SQL Question - Full-text indexing MS-WORD docs > My coldfusion web application uses a SQL 2000 DB on Win 2K server. > Presently, we are storing resumes of registered candidates in our database, > the table being used has the following design : > > USER_ID int 4 > ENTRY_DATE datetime 8 > UPDATE_DATE datetime 8 > USER_RESUME text 16 > > I have a full-text search index on my user_resume column, and my web > application allows users to perform keyword searches for resumes, so a > typical query (simplified) may look like this : > > select * from resume_table where contains(user_resume, 'keyword') > > Previously, resumes could only be uploaded in text form, by submitting from > a form. Now, I want users to be able to upload resumes as word documents, > which I will store in a new image column added to the resume_table table. I > want resumes in both formats to be searchable by full-text indexing. > > Firstly, how do I implement full-text indexing on the image column > containing MS Word documents ? > > Secondly, I need to do an integrated search on both text and ms word format > resumes, with minimal changes to my existing queries. I seem to have 3 > options (in decreasing order by amount of effort involved for me), though I > am not sure whether all of them will work : > > 1. Create another full-text index for the image column storing the ms word > docs. When doing keyword search, use both indexes. > > 2. Store the word documents in an image column, but do not index them. > Instead, somehow strip out the text from each document and store it in the > user_resume column, where it will be part of the existing full-text catalog. > > 3. Change the user_resume column to type image - let it store both text > from form submit and uploaded word documents. Rebuild a full-text index on > this column (Is this possible) ? > > I'm not sure about the feasibility of any of these options, or issues that > may arise. Would like suggestions as to the best alternative of the three, > or any other option I may have overlooked. > > Vishal. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
