Link to home
Start Free TrialLog in
Avatar of IMcMillan
IMcMillanFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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

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
ASKER CERTIFIED SOLUTION
Avatar of saoirse1916
saoirse1916
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of IMcMillan

ASKER

Thanks for this solutions this was exactly what I was looking for, Thank you very much for your help. A+