 |
|
|
 |
|
|
 |
| |
 |
|
<%
set rs=server.createobject("adodb.recordset")
sqltext="select top 8 * from news where type=303 order by news_id desc"
rs.open sqltext,conn,1,1
x=0
do while not rs.eof
%>
<%
rs.movenext
x = x+1
loop
rs.close
%> |
|
 |
| |
 |
|
<%
set rs=server.createobject("adodb.recordset")
sqltext="select top 8 * from news where type=402 order by news_id desc"
rs.open sqltext,conn,1,1
x=0
do while not rs.eof
%>
<%
rs.movenext
x = x+1
loop
rs.close
%>
|
|
 |
| |
 |
|
<%
set rs=server.createobject("adodb.recordset")
sqltext="select top 8 * from news where type=505 order by news_id desc"
rs.open sqltext,conn,1,1
x=0
do while not rs.eof
%>
<%
rs.movenext
x = x+1
loop
rs.close
%>
|
|
 |
 |
 |
<%
set rs=server.createobject("adodb.recordset")
sqltext="select * from v_news where type=201 order by news_id desc"
rs.open sqltext,conn,1,1
x=1
do while not rs.eof and x<=2
%>
<%
rs.movenext
x = x+1
loop
%>
|
|
|
 |
<%
'set rs=server.createobject("adodb.recordset")
'sqltext="select top 4 * from v_news where type=303 order by news_id desc"
'rs.open sqltext,conn,1,1
'x=0
do while not rs.eof and x<=4
%>
<%
rs.movenext
x = x+1
loop
%>
|
|
|
|
 |
<%
set rs=server.createobject("adodb.recordset")
sqltext="select top 4 * from v_news where type=202 order by news_id desc"
rs.open sqltext,conn,1,1
x=0
do while not rs.eof and x<=1
%>
<%
rs.movenext
x = x+1
loop
%>
|
|
 |
<%
'set rs=server.createobject("adodb.recordset")
'sqltext="select top 4 * from v_news where type=303 order by news_id desc"
'rs.open sqltext,conn,1,1
'x=0
do while not rs.eof and x<=8
%>
<%
rs.movenext
x = x+1
loop
rs.close
set rs=nothing
%>
|
|
| |
|
|
|
|
 |
|