使用asp查找后分页显示，第一页正常，在点击下一页时就出错? 400 报错

代码如下：

<%
  setrs=server.createobject("adodb.recordset")
   
  cz=request("search") '0为查找，不带search为全部显示列表没  
  xb=request.Form("xingb")
  xm=request.form("rcsearch")

  ifcz="0"then
   ifxm=""then
   ifxb="noxz"then
    sql="select*fromjyknryorderbyfbrqdesc"
   else
    ifrequest.Form("xingb")="1"then
    sql="select*fromjyknrywherexingbie='男'"&"orderbyfbrqdesc"
    else
     ifxb="2"then
      sql="select*fromjyknrywherexingbie='女'"&"orderbyfbrqdesc"
     else

      '错误在这？？？？？？？？？？？？？？？？

      'ifrequest.Form("xingb")=""then
      'sql="select*fromjyknrywherexingbie='女'"&"orderbyfbrqdesc"
      'endif
     endif
    endif   
   endif
   
   
   else
   '查询名字存在
     ifxb="noxz"then
    sql="select*fromjyknrywherexingming='"&xm&"'"
   else
    ifxb="1"then
     sql="select*fromjyknrywherexingming='"&xm&"'andxingbie='男'" &"orderbyfbrqdesc"
    else
     sql="select*fromjyknrywherexingming='"&xm&"'andxingbie='女'"&"orderbyfbrqdesc"
    endif
    
   endif

  
   endif
 
 
    
  else 
  
     
    '不属于查询，就业困难人员全部列表         
     sql="select*fromjyknry orderbyfbrqdesc"
    
 endif
 rs.opensql,cn,3,1
%>