<%
SqlList = "SELECT C.ProID, C.ProModel, C.ProName, C.ProImage1, C.ProImage2, A.MaxID, A.MaxName FROM ProductMax10 AS A INNER JOIN ProductList10 AS C ON A.MaxID = C.MaxID "
SqlList = SqlList + " WHERE C.ProID >= 1 And C.ProNew = 1 "
SqlList = SqlList + " ORDER BY C.ProRank, C.ProUpdateTime DESC , C.ProID DESC "
set RsList = server.CreateObject("adodb.recordset")
RsList.open SqlList, objConn, 1, 1
if RsList.eof or RsList.bof then
Response.Write("暂无新产品信息")
else
for RsList_i = 1 to 15
%><%
if not RsList.eof then
%>
<%
SqlList = "SELECT C.ProID, C.ProModel, C.ProName, C.ProImage1, C.ProImage2, A.MaxID, A.MaxName FROM ProductMax10 AS A INNER JOIN ProductList10 AS C ON A.MaxID = C.MaxID "
SqlList = SqlList + " WHERE C.ProID >= 1 And C.ProNew = 1 "
SqlList = SqlList + " ORDER BY C.ProRank, C.ProUpdateTime DESC , C.ProID DESC "
set RsList = server.CreateObject("adodb.recordset")
RsList.open SqlList, objConn, 1, 1
if RsList.eof or RsList.bof then
Response.Write("暂无新产品信息")
else
for RsList_i = 1 to 15
%><%
if not RsList.eof then
%>
