<%set rs=server.createobject("adodb.recordset")
sql="select top 5 * from SMT_sca where SMT_yp_id="&yp_id&" and SMT_key=1 and SMT_key1=1 and SMT_key2=1 order by SMT_id desc"
rs.open sql,conn,1,1
do while not rs.eof%>
·><%=rs("SMT_scatitle")%> <%=year(rs("SMT_begindate"))&"-"&month(rs("SMT_begindate"))&"-"&day(rs("SMT_begindate"))%>
<%rs.movenext
loop
rs.close%>
|
<%set rs=server.createobject("adodb.recordset")
sql="select top 3 * from SMT_cp where SMT_yp_id="&yp_id&" and SMT_key=1 and SMT_key1=1 and SMT_key2=1 order by SMT_id desc"
rs.open sql,conn,1,1
if rs.eof then
response.write"暂无产品 | "
else
do while not rs.eof
cpname=rs("SMT_cpname")
if len(cpname)>7 then cpname=left(cpname,6)&"..."%>
|
<%rs.movenext
loop
end if
rs.close%>
|