<% AutoID=ReqNum(Request("ID")) sql = "SELECT * FROM T_News WHERE T_News.Show = 'Y' AND AutoID = " & AutoID set rs = conn.execute(sql) NewsUrl = rs("NewsUrl") sql2 = "UPDATE T_News SET HitCount = HitCount + 1 WHERE AutoID = " & AutoID set rs2 = conn.execute(sql2) If not rs.eof Then If NewsUrl<>"" Then URL = NewsUrl else URL = "/news/news_content.asp?ID=" & AutoID End if End If Set rs = Nothing Set rs2=nothing Response.Redirect URL %>