<!--#include file="SQLconn.asp"-->
<% 
dim strID
strId=request("id")

dim fjsql
dim fjrs
dim strfilename
fjsql="select * from subjectfile  where fid='"&strId& "'"
Set fjrs= Server.CreateObject("ADODB.Recordset")
fjrs.open fjsql,conn,1,1
Response.ContentType = fjrs("fileContentType")

'Response.AddHeader   "Content-Disposition","attachment;   filename="&fjrs("filename")
Response.AddHeader   "Content-Disposition","inline;   filename="&fjrs("filename")
Response.BinaryWrite  fjrs.fields("filevalue").value
fjrs.close
set fjrs=nothing 
set conn=nothing 

%>