Question

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

Answer 1

'上一条信息显示 sql2=select top 1 * from productList10 where maxid=&maxid& and ProID>&id& order by ProID asc set rs2=objconn.execute(sql2) if rs2.eof or rs2.bof then topnews=没有了！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 productList10 where maxid=&maxid& and ProID<&id& order by ProID desc set rs3=objconn.execute(sql3) if rs3.eof or rs3.bof then topnews3=没有了！elseproid3=rs3(proid) title3=rs3(ProName) topnews3=<a href='newsshow.asp?maxid=&maxid&&id=&proid3&'>&title3&</a>end ifrs3.closeset rs3=nothing response.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>%> 这个可以 你试试