 |
||||||
|
||||||
 |
<%
set rs_news=server.createobject("adodb.recordset")
sqltext4="select top 5 * from news where bigclassname='企业新闻' order by id desc"
rs_news.open sqltext4,conn,1,1
%>
|
 |
 |
| <% set rs=conn.execute("select top 3 * from product where defaultpicurl<>'img/nopic.gif' and defaultpicurl<>'' order by id desc") i=1 do while not rs.eof title=title&rs("title") if i<>3 then title=title&"|" picpath=picpath&rs("defaultpicurl") if i<>3 then picpath=picpath&"|" url=url&"productshow.asp?id="&rs("id") if i<>3 then url=url&"|" i=i+1 rs.movenext loop set rs=nothing %> |