Question

修改asp一段图片滚动的数据库链接代码

<%
Const New_img=10
set rs_Product=server.createobject("adodb.recordset")
sqltext="select top " & New_img & " * from chanpin where bigname<>'图片连接' order by id desc"
rs_Product.open sqltext,conn,1,1
if not rs_Product.EOF then%> 把这段图片展示的代码修改成只提取数据库 推荐1或0的图片。而不是全部显示
及求解

Answer 1

sqltext="select top " & New_img & " * from chanpin where bigname<>'图片连接' and (推荐=1 or 推荐=0) order by id desc"