File upload to database

[Guest]

Hi,

I am trying to create an online employment application using FrontPage 2003
and MS Access 2003... I don't have a problem submitting forms to the database
but what I really would like to do is to have users fill out the application
AND be able to uploade their resume.... I think I know how to upload a file
to a folder in my web server but I would like to have a way to "link" the
file (resume) to the applicant... I thought that maybe there is a way to
store these file inside the database next to the applicant so I can query the
database....

Any ideas??

 

[Thomas A. Rowe]

You would have to custom code this using a ASP Upload component. Check with your web host to see
what they have available or are willing to install.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[P@tty Ayers]

I am trying to create an online employment application using FrontPage
2003
and MS Access 2003... I don't have a problem submitting forms to the
database
but what I really would like to do is to have users fill out the
application
AND be able to uploade their resume.... I think I know how to upload a
file
to a folder in my web server but I would like to have a way to "link" the
file (resume) to the applicant... I thought that maybe there is a way to
store these file inside the database next to the applicant so I can query
the
database....

Any ideas??

An idea: you could simply have applicants copy-paste their resume as plain
ASCII text into a textarea. That way you could easily link it to the
applicant, and the text would reside right in the database where you could
easily query it. The only thing you'd lose would be the formatting people
use on their resumes, but maybe you don't need that anyway. I've done it
this way and my client has been accepting applications for a couple of years
now.

Just a thought.

 

[Guest]

Thanks for the input.

I kind of like the idea of having applicants just pasting their resume since
I don't have the skills to write a custom ASP application. I guess you can
make that field a "memo" field right??

Thanks again.

 

[Paul M]

Or you could have resume form which they fill in and have separate fields
for resume info such as past employment, hobbies etc Then you could query
the database and have the record displayed in a table with separate cells
for each category
Paul M

 

[P@tty Ayers]

I kind of like the idea of having applicants just pasting their resume

since
I don't have the skills to write a custom ASP application. I guess you can
make that field a "memo" field right??

I'm not sure what it might be called in FP, but the HTML is <textarea>, a
multi-line text field.

 

[Andrew Murray]

in MS Access it is called a Memo field, which is the same thing as a "text
area".

 

[P@tty Ayers]

Sorry - I thought he was asking about the form field he needed to use in his
HTML. Right, if he's using Access for a database, he would want to use a
'Memo' field.

--
Patty Ayers | www.WebDevBiz.com
Free Articles on the Business of Web Development
Web Design Contract, Estimate Request Form, Estimate Worksheet
--

in MS Access it is called a Memo field, which is the same thing as a "text
area".