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!

re: FP, Access, & Uploading Images by Jim

Jim
Sat May 01 13:12:35 CDT 2004

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!
>
>.
>

re: FP, Access, & Uploading Images by Steve

Steve
Sat May 01 18:32:01 CDT 2004

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!
>>
>>.
>>
>.
>

Re: FP, Access, & Uploading Images by news

news
Sun May 02 01:25:20 CDT 2004

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" <anonymous@discussions.microsoft.com> wrote in message news:<715801c42fd4$80f09840$a301280a@phx.gbl>...
> 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!
> >>
> >>.
> >>
> >.
> >