Our jobbank program needs an upgrade. Currently, the resumes are pasted into FCKeditor and stored in a database in HTML format. However, this doesn't seem to be getting the job done, and we've received a deluge of complaints and demands for the ability to just upload a pdf/word document. Many of the job seekers have had trouble getting their resume looking just write because of all the spaces & other weird stuff people put in word documents.
We've gone through several upgrades and filters the post processing of resumes, but we still can't get it to look right. Here's how the search results work now: http://www.producejobsource.com/index.cfm?event=SearchUsers&query=sales&x=0&y=0&submit=&location=&jobtype=&radius=&school= The solution we're considering now is to allow job seekers to cut & paste their resume OR just upload it. But that will mean indexing the folder of resumes (all PDFs or Word Docs) as a collection so it can be searched on. I've made collections before and its no big deal, but I've never had to combine it with a SQL search too. Basically, I need to upgrade my resume search program from a strict SQL search based on "like'%string%" to one that combines SQL searchs with searches on a directory full of word and PDF documents and is somehow able to link those documents back to a user, and then display the search results in exactly the same way it currently does. Has anyone done anything like this and do you have any suggestions for how to proceed? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
