asp下载数据库某一字段内容

[漠叔]

比如表table中有一字段为content
现在要做一个下载功能,当用户点下载时把字段content中的内容做为一个txt文件提供给用户下载,应该如何做?

[hookee]

<%
s = "test text"

With Response 
	.Charset	= "GB2312"
	.ContentType= "application/octec-stream"
	.AddHeader "Accept-Ranges", "bytes"
	.AddHeader "Content-Length", LenB(s)
	.AddHeader "Content-Type", "application/octec-stream"
	.AddHeader "DownloadOptions", "noopen"
	.AddHeader "Content-Disposition","attachment; filename=test.txt"
	.BinaryWrite s
End With

%>

[syjeffdyg]

其实就是修改头元素head里面的content-type，楼上正解。

[漠叔]

问题解决,改为Response.Write s即可

[漠叔]

唉,改成Write后英文又不行了

[漠叔]

楼上的各位高手再帮看看,下载是可以了,但是下载的文件中汉字都成了乱码,页面上显示的时候是正常的,网页编码为gb2312

[lbcleo]

如果是文字是乱码,字母正常,如果你要改变模式,改成UTF-8才可以 charset=gb2312 这里去修改一下吧

[漠叔]

改utf-8也一样

[zhengmenghua]

测试了一下 提示错误 百度了一下 改为这样

<%
s = "test text"

With Response
.Addheader "Content-Type","text/html; charset=gb2312"
.ContentType= "application/octec-stream"
.AddHeader "Accept-Ranges", "bytes"
.AddHeader "Content-Length", LenB(s)
.AddHeader "Content-Type", "application/octec-stream"
.AddHeader "DownloadOptions", "noopen"
.AddHeader "Content-Disposition","attachment; filename=test.txt"
.BinaryWrite s
End With

%>