::::::::::如何将存在数据库中的二进制文件，按照指定的文件类型读出来:::::::::::

[sq0421]

我通过上传图片文件到数据库的方法，可以把其他类型的文件也存到数据库image字段中，但采用原来的读图片的方法来读这样的数据

Response.ContentType = "image/*"
Response.BinaryWrite rs("file_content")

也能读，但文件类型就不对了，保存到硬盘上的文件扩展名为.asp
如何解决？？？？？？？？？？？？？

[ipman]

数据库添加一个类型字段不就可以了吗

[sq0421]

关键是在页面上怎么写，链接到该页比如：11.asp，那么他就会提示你保存，保存的文件名称就默认为11.asp

[sq0421]

没人理我...up一下

[sq0421]

up again...

[风轻狂]

我也想知道

[风轻狂]

Response.ContentType = "image/gif"

Response.ContentType = "image/jpeg"

[nchen123]

Select Case lcase(Right(fName, 4))
Case ".asf"
ContentType = "video/x-ms-asf"
Case ".avi"
ContentType = "video/avi"
Case ".doc"
ContentType = "application/msword"
Case ".zip"
ContentType = "application/zip"
Case ".xls"
ContentType = "application/vnd.ms-excel"
Case ".gif"
ContentType = "image/gif"
Case ".jpg", "jpeg"
ContentType = "image/jpeg"
Case ".wav"
ContentType = "audio/wav"
Case ".mp3"
ContentType = "audio/mpeg3"
Case ".mpg", "mpeg"
ContentType = "video/mpeg"
Case ".rtf"
ContentType = "application/rtf"
Case ".htm", "html"
ContentType = "text/html"
Case ".asp"
ContentType = "text/html"
Case ".txt"
ContentType = "text/plain"
Case Else
ContentType = "application/octet-stream"
End Select

[nchen123]

Response.ContentType = ContentType

[DeltaCat]

http://hongwen.Y365.com/sjCatstudio.rar