Question...

[skc]

Hi,

I have been using FP98 and FP2000 for a number of years
now. I always use Access as my backend database and
generate custom .asp code to access the database and to
interrogate the data with custom SQL.

I am now going to engage in a new project that involves
uploading files - hence my move to FP2003. I have not
installed it yet, but I have some questions before I begin
playing with it...

Application
-----------
This is going to be for a lighting company so to let them
fully control their stock lists. The lighting company
will take a pic of a lamp shade, fill in an online webform
and attach a picture from their digicam to be uploaded to
an access database. Similarly, records can be deleted
using webforms and custom .asp.

My ISP has the latest FP extensions and hosting is
provided by an NT box - good news!

Questions
---------

1. Is Access good for this? I do not want to go down the
SQL route, but for managing around 100 different items of
lamps and uploading pictures, would Access be efficient?

2. Are there any pointers on how to get the file upload
component working in a web form so pics can be posted into
an Access table?

3. Any other things I should know about before I explore
FP2003?

Thanks,

skc

 

[Thomas A. Rowe]

1. I would not store the images in the database, not matter which DB you are using.
2. Ask you host which ASP Upload component they have available or are willing to install, such as
ASPUpload.
3. Access should work fine.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[skc]

Thomas,

Can you point the upload in FP03 to go to the images
directly, if someone was to upload images to the webserver?

skc

-----Original Message-----
1. I would not store the images in the database, not matter which DB you are using.
2. Ask you host which ASP Upload component they have

available or are willing to install, such as

 

[chris leeds]

I believe you can direct the upload (fp upload form) to any folder you like.

IMHO you may be better off finding and modifying a "shopping cart" script to
suit your needs. this is basically what you're looking to do anyway. It's
always easier to remove features from a script than it is to add them. ;-)

HTH

 

[Thomas A. Rowe]

Maybe, however based on what your wrote, you need a will need to use a ASP Upload component and not
the FP upload component.

The various ASP Upload components available, give you full control over managing the images (rename,
resizing, restriction the types of uploads, etc.)

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[John Jansen \(MSFT\)]

You can upload the images to the Images folder, and you can even map the
path to your images folder properly for insertion in the database.

I think it is probably best to use your ISP's ASP upload component instead
of the FrontPage form upload component because the FrontPage Form is just
not really designed for this; however, if your ISP doesn't have one and you
have no other choice, here is a KB article and white paper that should do
the trick for you.

http://support.microsoft.com/default.aspx?scid=kb;en-us;288328

 

[skc]

where can i get an asp upload component from. ISP says to
use my own...please help.

skc

-----Original Message-----
Maybe, however based on what your wrote, you need a will

need to use a ASP Upload component and not

the FP upload component.

The various ASP Upload components available, give you

full control over managing the images (rename,

 

[Thomas A. Rowe]

Here is the one I use, however like all ASP components, it must be installed by the host for your
use.

ASP Upload
http://www.aspupload.com

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================