sql=“select * from product where 1=1是什么意思?

发布网友 发布时间：2022-06-09 22:37

我来回答

共1个回答

热心网友 时间：2023-12-12 06:07

'上一条信息显示sql2=select top 1 * from proctList10 where maxid=&maxid& and ProID>&id& order by ProID ascset rs2=objconn.execute(sql2)if rs2.eof or rs2.bof thentopnews=没有了！elseproid1=rs2(proid)title2=rs2(ProName)topnews=<a href='newsshow.asp?maxid=&maxid&&id=&proid1&'>&title2&</a>end ifrs2.closeset rs2=nothing'下一条信息显示sql3=select top 1 * from proctList10 where maxid=&maxid& and ProID<&id& order by ProID descset rs3=objconn.execute(sql3)if rs3.eof or rs3.bof thentopnews3=没有了！elseproid3=rs3(proid)title3=rs3(ProName)topnews3=<a href='newsshow.asp?maxid=&maxid&&id=&proid3&'>&title3&</a>end ifrs3.closeset rs3=nothingresponse.Write<div style='width:100%; height:40px; font-size:14px;font-weight:bold; padding-top:10px;' align=center><span style='color:#144789;'>&title&</span></div><div style='width:100%;padding:5px; background:#F8F8F8;' align=center>  <span style='color:#999;'>点击率：[&hist&]</span>  <span style='color:#FF0000;'>发布时间：[&uptime&]</span>  <span style='font-size:12px;'>双击滚屏查看</span></div>response.Write<div style='padding:8px;width:100%; line-height:25px;'>&content&</div>response.Write<div style='padding:10px;width:100%; line-height:28px; border-top:#ECECEC 1px solid;border-bottom:#ECECEC 1px solid'>◎<b>上一条:</b>&topnews&<br>◎<b>下一条:</b>&topnews3&</div>%>这个可以 你试试