resume database

M

midwest211

I'm using FP'03 with the web page ->database
and I've got all the necessary fields for querying, name, address, Degree, etc
but I want the user to be able to upload his/her resume along with the information on the form and when the database of information is queried, to have links to the resumes of the people that fit the search criteria. I think it might have something to do with referencing the primary key, but I'm not sure
 
J

Jim Buyens

-----Original Message-----
I'm using FP'03 with the web page ->database,
and I've got all the necessary fields for querying, name,
address, Degree, etc. but I want the user to be able to
upload his/her resume along with the information on the
form and when the database of information is queried, to
have links to the resumes of the people that fit the
search criteria. I think it might have something to do
with referencing the primary key, but I'm not sure.
Click to expand...

Using FrontPage alone, you can't receive uploaded files
and update a database from the same form submission.
Instead, you'd need to program an ASP or ASP.NET page that
does both jobs together.

Typically, that page would store the resume file name in
the database. Then, on page 2 of the DRW that lists the
records, you would configure a customn query that returns
hyperlinks to the resume for that record. For example:

SELECT '<a href="resumes/' & [resumefile] & '">' &
[seekername] & '</a>' as seekerlink, * FROM ...

Then, in the finished Database Results Region, right-click
the seekerlink field, select Database Column Value
Properties, and check the Column Value contains HTML box.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
Top