% set rs=server.createobject("adodb.recordset") sql="select * from flash where id="&request("id") rs.open sql,conn,1,1 url=rs("url") %>