高考问答安徽玻璃钢储罐厂家:ASP编程问题
来源：百度文库 编辑：高考问答 时间：2024/04/30 08:21:18
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不是很难的