至少一个参数没有被指定值（还没解决）！201行报错

set rs_huiyuan =server.createobject("ADODB.RecordSet")
  sql="select * from gongzuo where 1=1"
  if request.Cookies("shiwei_id")<>1 and lookhuiyuan="yes" and fla90="0" then
    sql=sql&" and id_login="&request.Cookies("shiwei_id")
  end if
  if nowzu<>"" then
    sql=sql&" and id_zu="&nowzu
  end if
  if nowkeyword<>"" then
    sql=sql&" and (username like '%"&nowkeyword&"%' or card like '%"&nowkeyword&"%' or tel like '%"&nowkeyword&"%' or qq like '%"&nowkeyword&"%' or email like '%"&nowkeyword&"%')"
  end if
  
  if request("order1")<>"" then
    sql=sql&" order by username "&request("order1")
  elseif request("order2")<>"" then
    sql=sql&" order by xinbie "&request("order2")
  elseif request("order3")<>"" then
    sql=sql&" order by qq "&request("order3")
  elseif request("order4")<>"" then
    sql=sql&" order by startdate "&request("order4")
  elseif request("order5")<>"" then
    sql=sql&" order by card "&request("order5")
  elseif request("order6")<>"" then
    sql=sql&" order by jifen "&request("order6")
  elseif request("order7")<>"" then
    sql=sql&" order by id_zu "&request("order7")           
  else
    sql=sql&" order by id desc"  
  end if  
   
  rs_huiyuan.open sql,conn,1,3   (201行）

把gongzuo  换成 huiyuan  搜索时就正常，但是表内的内容也同时从gongzuo里面的内容变成huiyuan里面的内容了。换回来搜索就报错。 高手解决下啊.


[ 本帖最后由 lxb0592 于 2012-6-9 00:01 编辑 ]