%
sql = "select news_id, news_title_"&lang&", news_time from tb_news where (nc_id = 'news') and (news_state = 1) order by news_time desc"
rs.open sql,conn,3,1
rs.pagesize = 10
%>
News List
| ID |
Title |
Date |
<%dim sn:sn=MM_offset:While ((Repeat1__numRows <> 0) AND (NOT rs.EOF)):sn=sn+1%>
|
<%=(sn)%> |
|
<%=(formatdatetime(rs("news_time"),2))%> |
<%Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rs.MoveNext()
Wend%>
|
|
<%closeobject(rs)%>