前边还有个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 imgsize0 and audit=1 order by newsid DESC" else '选择newsid值最大的第一条记录,符合以下条件1、imgsize字段有值且不是02、auditid=1翻译了半天,其实都是查询的sql语句,大同小异,自己领悟一下,asp不是很难的