How do I add images to a database in FrontPage?

[Guest]

I am making a web site that will allow another person to edit the database (I
used the DRW and DIW). The database is all text and numbers except for a
couple of fields for pictures. My hope is that she will be able to upload
pictures into the database for each record.

How do I make the submission form so she can upload images? I tried adding
a form component to upload files, but it didn't work with just a simple
Insert/Form/File Upload method. Maybe that's the right thing, but there are
more settings I should have used.

Help!

Thanks,

Toni

 

[Kathleen Anderson [MVP - FrontPage]]

Inline.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

I am making a web site that will allow another person to edit the database
(I
used the DRW and DIW). The database is all text and numbers except for a
couple of fields for pictures. My hope is that she will be able to upload
pictures into the database for each record.

The pictures should not be stored in the database - they should be in the
images folder of your web and the location ( images/mypicture.jpg ) stored
in a field in your database. More info:
http://support.microsoft.com/kb/216285/en-us

How do I make the submission form so she can upload images? I tried
adding
a form component to upload files, but it didn't work with just a simple
Insert/Form/File Upload method. Maybe that's the right thing, but there
are
more settings I should have used.

You can use the FrontPage File Uplaod component for that if your host allows
it:
http://www.frontpagehowto.com/fileupload/FrontPageFileUploadComponent_files/frame.htm#slide0001.htm

 

[Guest]

Now I'm going to sound really silly....

1. What does "Inline" mean? Is it in a menu in FP, and if so, which one?
2. To allow the user to upload an image to the database, do I need to edit
the Submission_form.asp page with an "inline" object?

I've come so far...hope this is conquerable.

Toni

 

[Guest]

Duh....I see that by "inline" you meant to read below between my lines. Ha!
You can see that I've not used a discussion group before!

Toni

 

[Guest]

I might be having an "aha" moment! See if I am following correctly here:

1. Make a separate page for the user to upload the pictures (with a form).
Have the user save all images with predictable file names (like item1a.jpg,
item1b.jpg, item1c.jpg to make three images for item1).

2. In the database's fields for photo 1, photo 2, and photo 3, the user
would enter the name and folder of the uploaded images. In my design, I have
to somehow make that become a link.

If the customer/user stops selling a product, I will have to manually go
into that upload folder and delete pictures periodically so I don't fill up
my server.

Is this sort of correct?

Thanks!

Toni

 

[Kathleen Anderson [MVP - FrontPage]]

Inline

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

I might be having an "aha" moment! See if I am following correctly here:

1. Make a separate page for the user to upload the pictures (with a
form).
Have the user save all images with predictable file names (like
item1a.jpg,
item1b.jpg, item1c.jpg to make three images for item1).

Yes, but before you start down this path, make sure it's something your web
host supports.

2. In the database's fields for photo 1, photo 2, and photo 3, the user
would enter the name and folder of the uploaded images. In my design, I
have
to somehow make that become a link.

Yes, and the KB article shows you how to do that.

If the customer/user stops selling a product, I will have to manually go
into that upload folder and delete pictures periodically so I don't fill
up
my server.

Yes, and I would also either mark the record in the databse as such or
delete the record altogether, so potential customers don't try and order it
anyway.

Is this sort of correct?

You're getting there.

One other thing - when you reply to a post in this group, please keep the
original message in your reply.

Thanks.

 

[Andrew Murray]

Comments are within your original post, rather than relying all in one hit
Kathleen has responded to each of your questions in turn, since your post
has multiple parts to it.