home peg　|　news　|　products　|　about us　|　design　　

<%ID=Request("t_id") conn = Server.CreateObject("ADODB.Connection") conn.Open("driver={Microsoft Access Driver (*.mdb)};dbq=" + Server.MapPath("news.mdb")) rs = Server.CreateObject("ADODB.Recordset") sqlstr="Select * from t_news where n_tid="+ID+" order by n_date desc " rs.Open(sqlstr, conn, 3,1); rs.PageSize =20; if(rs.Eof){ Response.Write("数据库中无记录"); Response.End();}%>

<% for( i = 0; i < rs.PageSize; i++) { if(!rs.eof){ var dd=new Date(rs("n_date")); s=dd.getYear()+"-"; if ((dd.getMonth()+1)>10) { s=s+(dd.getMonth()+1)+"-"; }else{ s=s+"0"+(dd.getMonth()+1)+"-"; } if (dd.getDate()>10) { s=s+dd.getDate(); }else{ s=s+"0"+dd.getDate(); } %> <% rs.movenext(); } } %>

The 99th Session Chinese Export Commodities Fair