<% set rs=server.CreateObject("adodb.recordset") newsid=saferequest("newsid",1) sql="select * from producta where p_id=" & newsid rs.open sql,conn,1 downfile="uppic/"& rs("p_image1")&"" rs.close set rs=Nothing response.Redirect(downfile) %>