<% strsql="select * from SingleDirectoryNews where column_id=80 " Set objRs = Server.CreateObject("adodb.recordset") objRs.Open strSql,objConn,1,1 if not objRs.eof then response.Write objRs("column_detail") end if objRs.close set objRs=nothing %>