28,409
社区成员




<%
set rs_2 = server.createobject("adodb.recordset")
sql="select * from company where tjsq='2' order by id desc"
rs_2.open sql,conn,1,1
response.write"<table width='100%' border='0' cellspacing='0' cellpadding='0'>"
if rs_2.bof and rs_2.eof then
response.write "<tr><td align='center'>暂无相关信息</td></tr>"
else
for g = 1 to 9
if g mod 2 = 0 then
bgcolor="#F2F7FD"
else
bgcolor="#ffffff"
end if
rs_2.movenext
next
response.write"<tr bgcolor="&bgcolor&">" '为什么只有第一行变色,后面的就不变了呢?
for i=1 to 9
if rs_2.eof then exit for
response.write"<td width='33%' height='23'>"
if Len(rs_2("gsname"))<=14 then
NewsName=rs_2("gsname")
else
NewsName=Left(rs_2("gsname"),12)&"..."
end if
response.write "<table ><tr><td align=left> <IMG width=6 height=7 src='Images/zptu.gif'> <a href=zcfgview.asp?ID="&rs_2("id")&" target=_blank title="&rs_2("gsname")&">"&NewsName&"</a></td>"
response.Write "</tr></table >"
response.write"</td>"
if i mod 3 = 0 then '每行显示3条数据。
response.write"</tr>"
end if
rs_2.movenext
next
end if
response.write "</table>"
rs_2.close
set rs_2=nothing
%>
<%
set rs_2 = server.createobject("adodb.recordset")
sql="select * from company where tjsq='2' order by id desc"
rs_2.open sql,conn,1,1
response.write"<table width='100%' border='0' cellspacing='0' cellpadding='0'>"
if rs_2.bof and rs_2.eof then
response.write "<tr><td align='center'>暂无相关信息</td></tr>"
else
if i mod 2 = 0 then bgcolor="#F2F7FD" else bgcolor="#ffffff"
response.write"<tr bgcolor="&bgcolor&">" '为什么只有第一行变色,后面的就不变了呢?
for i=1 to 9
if rs_2.eof then exit for
response.write"<td width='33%' height='23'>"
if Len(rs_2("gsname"))<=14 then
NewsName=rs_2("gsname")
else
NewsName=Left(rs_2("gsname"),12)&"..."
end if
response.write "<table ><tr><td align=left> <IMG width=6 height=7 src='Images/zptu.gif'> <a href=zcfgview.asp?ID="&rs_2("id")&" target=_blank title="&rs_2("gsname")&">"&NewsName&"</a></td>"
response.Write "</tr></table >"
response.write"</td>"
if i mod 3 = 0 then '每行显示3条数据。
response.write"</tr></tr>"
end if
rs_2.movenext
next
end if
response.write "</table>"
rs_2.close
set rs_2=nothing
%>