Solved

Uploading Word Docs with asp and storing in SQL server 2000Question

Posted on 2008-10-22
2
258 Views
Last Modified: 2013-12-24
Hi All ,
Im currently working on a website that requires the functionality of being able to accept uploaded CVs from registered users and storing them online so they can attach them to job applications, get headhunted by recruiters,

I am a little confused over how to store these CV's in SQL, My options are this,

1. User copies and Paste their CV into an RTF box and hits submit to save to the database in a text field or blob,

2. User attached their CV and then the CV is saved toi disk

I am trying to find the best solution to accomplish this eg storing the CV word docs in the actual database using BLOBS or storing CVs in a folder and then the next concern I have is how can the recruiters search on specific key words if saved to the DB or the file on disk, guys, this is my only stumling block and I cant seem to get my head around how to achieve this.

I have seen job sites where users can copy and paste their CV into an RTF control and recruiters can search on it. how they do this I have not idea,

Any ideas or examples would be much appreciated ?

(Using ASP, Windows XP workstation, server, SQL SERVER 2000)

Many Thanks
0
Comment
Question by:IMcMillan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Accepted Solution

by:
saoirse1916 earned 500 total points
ID: 22788161
If you want to be able to search the files you'll definitely want to store the file itself in the database.  But you don't have to make the users copy/paste to do that -- you can upload a Word file into a varbinary datatype (or image, if you don't have varbinary).  Enable fulltext indexing on that field and build your index and the field is then searchable.

Here's a few links I used when setting this up on one of my sites:
http://www.codeproject.com/KB/architecture/sqlfulltextindexing.aspx - full text indexing
http://www.sitepoint.com/blogs/2006/11/12/sql-server-full-text-search-protips-part-1-setup/ - full text indexing
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=8525&lngWId=4 - uploading files into the DB
0
 

Author Closing Comment

by:IMcMillan
ID: 31508965
Thanks for this solutions this was exactly what I was looking for, Thank you very much for your help. A+
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question