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]

On Fri, 12 Nov 2004 17:15:40 -0500, ck****@fuse.net wrote:

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?

On Sat, 13 Nov 2004 00:31:39 GMT, je*********@zina.com (Jeff Cochran)
uttered:

On Fri, 12 Nov 2004 17:15:40 -0500, ck****@fuse.net wrote:

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

[Bob Barrows [MVP]]

ck****@fuse.net wrote:

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
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Larry Bud]

je*********@zina.com (Jeff Cochran) wrote in message news:<41*****************@msnews.microsoft.com>...

On Fri, 12 Nov 2004 17:15:40 -0500, ck****@fuse.net wrote:

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.

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.