Download from database via asp

[ckerns]

What I want to do is this via asp

a. Store file in database (I can do this)
b. Filter for a record (I can do this)

When page loads, I'd like to
c. Have that record display on web page and have user be able to
download the file (BLOb) in this record via a link.

Any hints here?

tia

 

[Jeff Cochran]

What I want to do is this via asp

a. Store file in database (I can do this)
b. Filter for a record (I can do this)

When page loads, I'd like to
c. Have that record display on web page and have user be able to
download the file (BLOb) in this record via a link.

Any hints here?

Store the file outside the database and just store a location. Link
to that location.

Jeff

 

[ckerns]

How to do this? Any links that might help?

Store the file outside the database and just store a location. Link
to that location.

Jeff

 

[Bob Barrows [MVP]]

What I want to do is this via asp

a. Store file in database (I can do this)
b. Filter for a record (I can do this)

When page loads, I'd like to
c. Have that record display on web page and have user be able to
download the file (BLOb) in this record via a link.

Any hints here?

tia

http://www.aspfaq.com/show.asp?id=2149

 

[Larry Bud]

Store the file outside the database and just store a location. Link
to that location.

The problem with this is that if you have a secure database, you may
not want any old user to be able to copy and distribute the URL and
download your image. You also could run into naming conventions.
What happens if a user tries to upload an image with the same filename
as an existing file? Now he has to rename, and reupload the file.

We have thousands of images, PDF files, even AVIs and MPEGs in a
database with no ill effect.