File fetch from database using asp

Question

I am storing some the binary data for some files in a database (yes, I know this can be a bad idea). I am able to get the files out, with the correct content type, since I have stored it. But I'm having trouble getting the file to the client with the right filename. Right now I have the following code in a file called get_file.asp:

sSQL = "SELECT filename, contenttype, binarydata FROM new_attachment WHERE filename = '" & filename & "'"

oRs.Open sSQL, conn, 3, 3

If Not oRs.EOF Then
    Response.ContentType = oRs(1)
    Response.BinaryWrite oRs(2)

End if

This will return files correctly, but with the filename of 'get_file.asp', instead of, say, 'myfile.txt'. The url visited is .../get_file.asp?filename=myfile.txt.

Is there a way I could change the name of the file when the browsers prompts the user to save it somewhere?

I was dealing with a similar issue here: stackoverflow.com/questions/440892/… — cdeszaq
– cdeszaq, Commented Jan 18, 2012 at 16:30

Diodeus - James MacFarlane · Accepted Answer · 2012-01-18 16:28:51Z

2

You need to send out the correct header:

Response.ContentType = "text/html"
Response.AddHeader "Content-Disposition", "attachment; filename=YOURFILE.TXT"

answered Jan 18, 2012 at 16:28

Diodeus - James MacFarlane

115k33 gold badges164 silver badges180 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Oded · Accepted Answer · 2012-01-18 16:28:18Z

1

You need to add a Content-Disposition header.

The header should look like this:

Content-Disposition: attachment; filename=<name of file>

Side note: The way you are concatenating SQL is open to SQL Injection - you should be using parameters.

answered Jan 18, 2012 at 16:28

Oded

501k102 gold badges900 silver badges1k bronze badges

Collectives™ on Stack Overflow

File fetch from database using asp

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related