各位好啊，我想问一下下面的语句该如何简写
<%
if nowxiaoqu="" then
    sql="select * from login order by xiaoqu,id"
  else
    sql="select * from login where xiaoqu="&nowxiaoqu&" order by id"
  end if
  set rs_login=conn.execute(sql)
  do while rs_login.eof=false

if nowbumen="" then
    sql="select * from login order by bumen,id"
  else
    sql="select * from login where bumen="&nowbumen&" order by id"
  end if
  set rs_login=conn.execute(sql)
  do while rs_login.eof=false
  %>

天啊，徒弟，我星期五白给你上课了！
    sql="select * from login where 1=1"
  if nowxiaoqu<>"" then
    sql=sql&"and xiaoqu="&nowxiaoqu
  end if
  if nowbumen<>"" then
    sql=sql&" and bumen="&nowbumen
  end if
    sql=sql&" order by xiaoqu,bumen,id"
  set rs_login=conn.execute(sql)
  do while rs_login.eof=false
  %>

哎哟，我真是笨啊~~谢师父指点！

原来还可以这么写呀！