% NewsId=Request("NewsId") set rs=Server.CreateObject("ADODB.RecordSet") sql= "select * from News where Pubdate<= now() and OffDate> now() and NewsId="&request("NewsId") rs.open sql,conn,1,1 %>