Set rs = Server.CreateObject("ADODB.RecordSet")
sql="Select count(*) as mycount from SL_news where N_author="&session("M_login")
rs.open sql,conn,1,1
response.write"共有记录:"
response.write(rs("mycount"))
rs.close
set rs=nothing
表里有符合条件的记录，为什么不能显示？？

sql="Select count(*) as mycount from SL_news where N_author='"&session("M_login")&"' "
这样就可以了