我做了个站内统计信息，老出错，帮忙看一下

<%
set rslg=server.createobject("adodb.recordset")
sqllg="select * from Class"
rslg.open sqllg,conn,1,1
if rslg.eof and rslg.bof then
rslg.mvoefirst
else
for i=1 to rslg.recordcount-1
i=rslg("ClassName")
set rslogin=server.createobject("adodb.recordset")
sqllogin="select count(ClassName) from News where ClassName='i'"
rslogin.open sqllogin,conn,1,1
if not (rslogin.eof and rslogin.bof) then
total=rslogin.fields(0).value
end if
response.write total
rslg.movenext
next
end if
%>

我的CLASSNAEM里有六个类，现在也能这些记录打出来了，但是，还不能把NEWS里的记录统计出来，帮忙看看
<%
set rslg=server.createobject("adodb.recordset")
sqllg="select * from Class"
rslg.open sqllg,conn,1,1
if rslg.eof and rslg.bof then
rslg.mvoefirst
else
for i=1 to rslg.recordcount
a=rslg("ClassName")
response.write a
set rslogin=server.createobject("adodb.recordset")
sqllogin="select count(ClassName) from News where ClassName='a'"
rslogin.open sqllogin,conn,1,1
if not (rslogin.eof and rslogin.bof) then
total=rslogin.fields(0).value
end if
response.write total
rslg.movenext
next
end if
%>

知道了，
是这样的
sqllogin="select count(clasName) from news where classname='"&a&"'"