<% sql="select * from prod where id="&request("id") set rs=getmdb(sql) if not isnull(rs("pic1")) then response.binarywrite rs("pic1") else response.redirect "images/jsz.gif" end if rs.close set rs=nothing %>