杭州交通信息网麒麟刺灵气攻击怎么用:ASP编程问题
来源：百度文库 编辑：杭州交通信息网 时间：2024/05/03 11:47:57
sql="select top " & n & " * from news where borderid=" & cstr(borderid) & " and audit=1 order by newsid DESC"
sql="select top " & n & " * from news where audit=1 order by hits DESC" else sql="select top " & n & " * from news where typeid=" & cstr(typeid) & " and audit=1 order by hits DESC"
sql="select top 1 * from news where imgsize<>0 and audit=1 order by newsid DESC" else
sql="select top 1 * from news where borderid=" & cstr(borderid) & " and imgsize<>0 and audit=1 order by newsid DESC"
谁帮忙解释下
前边还有个if吧 你落掉了
if then
sql="select top " & n & " * from news where typeid=" & cstr(typeid) & " and audit=1 order by newsid DESC" '从news表中按照newsid编号升序并且audit字段值为1的记录中取出n条记录
else
sql="select top " & n & " * from news where borderid=" & cstr(borderid) & " and audit=1 order by newsid DESC" '从news表中按照newsidid编号升序并且audit字段值为1且borderid=转化为数值类型的borderid变量的记录中取出n条记录
sql="select top " & n & " * from news where audit=1 order by hits DESC" else sql="select top " & n & " * from news where typeid=" & cstr(typeid) & " and audit=1 order by hits DESC"
'从news表中按照hits字段的值升序并且audit字段值为1且typeid=转化为数值类型的borderid变量的记录中取出n条记录
sql="select top 1 * from news where imgsize<>0 and audit=1 order by newsid DESC" else
'选择newsid值最大的第一条记录，符合以下条件
1、imgsize字段有值且不是0
2、auditid=1
翻译了半天，其实都是查询的sql语句，大同小异，自己领悟一下，asp不是很难的