FP, Access, & Uploading Images

J

Julie

I have used the wizard and create a page that returns
queries, another allowing the user to enter records. I
now want to be able to have the user upload an image into
the database. I assume the best way is to have a button
to browse to locate, then upload.

I have an alumni site that really needs to have the
ability for the users to upload images, please help. I
have had several requests for this and I cannot figure out
how to do it, any help would be appreciated!
 
J

Jim Buyens

This sort of thing usually involves three main tasks.

1. Create a form that can upload files. To do this in
FrontPage, add a File Upload control to your forms
page, configure it to save files in the folder you
want, and configure the folder properties to permit
anonymous uploads.

2. Save the uploaded filename in the alum's database
record. Unfortunately, FrontPage can't receive
file uploads and update databases from the same form.
So instead, you'd have to configure the form to send
you mail, and then you'd have to update the database
records manually (using the Database Interface Wizard,
for example.)

Updating the database manually would also give you
the opportunity to review the pictures and move
the legitimate ones to a "safe" area. (Inevitably,
you're going to get a few pictures of clowns,
animals, and naked people, and you probably want
to double-check those before going "live".)

3. Modify your reporting pages to create <img> tags
if the alum's record contains a picture name.
If you're using the Database results Wizard, for
example, you need to create a custom query that
contains code like this:

SELECT IIf("" & [picname]<>"","<img src=""images/" &
[picname] & """>") AS pictag, ...

and then, in the finished Database Results Region,
configure the pictag Database Column Value
Properties as Column Value Contains HTML.

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)
|/---------------------------------------------------
*----------------------------------------------------
 
S

Steve

How do you configure the folder properties to permit
anonymous uploads? When I right click on the folder
properties, the 3 option boxes are grayed out.
-----Original Message-----
This sort of thing usually involves three main tasks.

1. Create a form that can upload files. To do this in
FrontPage, add a File Upload control to your forms
page, configure it to save files in the folder you
want, and configure the folder properties to permit
anonymous uploads.

2. Save the uploaded filename in the alum's database
record. Unfortunately, FrontPage can't receive
file uploads and update databases from the same form.
So instead, you'd have to configure the form to send
you mail, and then you'd have to update the database
records manually (using the Database Interface Wizard,
for example.)

Updating the database manually would also give you
the opportunity to review the pictures and move
the legitimate ones to a "safe" area. (Inevitably,
you're going to get a few pictures of clowns,
animals, and naked people, and you probably want
to double-check those before going "live".)

3. Modify your reporting pages to create <img> tags
if the alum's record contains a picture name.
If you're using the Database results Wizard, for
example, you need to create a custom query that
contains code like this:

SELECT IIf("" & [picname]<>"","<img src=""images/" &
[picname] & """>") AS pictag, ...

and then, in the finished Database Results Region,
configure the pictag Database Column Value
Properties as Column Value Contains HTML.

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)
|/---------------------------------------------------
*----------------------------------------------------

-----Original Message-----
I have used the wizard and create a page that returns
queries, another allowing the user to enter records. I
now want to be able to have the user upload an image into
the database. I assume the best way is to have a button
to browse to locate, then upload.

I have an alumni site that really needs to have the
ability for the users to upload images, please help. I
have had several requests for this and I cannot figure out
how to do it, any help would be appreciated!

.
.
 
J

Jim Buyens

You have to open your live site (or the site you're testing
with) using an http:// URL. Then, in Folder Properties, you
have to clear Allow Scripts To Be Run before you select
Allow Anonmymous Uploads To This Directory.

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)
|/---------------------------------------------------
*----------------------------------------------------




Steve said:
How do you configure the folder properties to permit
anonymous uploads? When I right click on the folder
properties, the 3 option boxes are grayed out.
-----Original Message-----
This sort of thing usually involves three main tasks.

1. Create a form that can upload files. To do this in
FrontPage, add a File Upload control to your forms
page, configure it to save files in the folder you
want, and configure the folder properties to permit
anonymous uploads.

2. Save the uploaded filename in the alum's database
record. Unfortunately, FrontPage can't receive
file uploads and update databases from the same form.
So instead, you'd have to configure the form to send
you mail, and then you'd have to update the database
records manually (using the Database Interface Wizard,
for example.)

Updating the database manually would also give you
the opportunity to review the pictures and move
the legitimate ones to a "safe" area. (Inevitably,
you're going to get a few pictures of clowns,
animals, and naked people, and you probably want
to double-check those before going "live".)

3. Modify your reporting pages to create <img> tags
if the alum's record contains a picture name.
If you're using the Database results Wizard, for
example, you need to create a custom query that
contains code like this:

SELECT IIf("" & [picname]<>"","<img src=""images/" &
[picname] & """>") AS pictag, ...

and then, in the finished Database Results Region,
configure the pictag Database Column Value
Properties as Column Value Contains HTML.

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)
|/---------------------------------------------------
*----------------------------------------------------

-----Original Message-----
I have used the wizard and create a page that returns
queries, another allowing the user to enter records. I
now want to be able to have the user upload an image into
the database. I assume the best way is to have a button
to browse to locate, then upload.

I have an alumni site that really needs to have the
ability for the users to upload images, please help. I
have had several requests for this and I cannot figure out
how to do it, any help would be appreciated!

.
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top