标题:请教一个错误问题(至少有一个值没有被指定)
取消只看楼主
eournet
Rank: 2
等 级:论坛游民
帖 子:103
专家分:26
注 册:2010-5-22
结帖率:55.56%
已结贴  问题点数:10 回复次数:1 
请教一个错误问题(至少有一个值没有被指定)
'取得搜索关键字  
nowxinbie=request("xinbie")
nowkeyword=request("keyword")
%>
<table width="100%" border="0" cellpadding="0" cellspacing="2" align="center">
<form name="form2">
  <input type="hidden" name="form" value="<%=request("form")%>">
  <input type="hidden" name="field" value="<%=request("field")%>">
  <input type="hidden" name="field2" value="<%=request("field2")%>">
  <input type="hidden" name="field3" value="<%=request("field3")%>">
  <input type="hidden" name="field4" value="<%=request("field4")%>">
  <tr>
    <td width="5%" height="30"> </td>
    <td width="95%" align="right">
      项目稽核、验收整改进度情况查询:
      <select name="xinbie" onChange="form2.submit()" size="1">
        <option value="">请选择整改阶段</option>
        <option value="项目稽核">项目稽核</option>
          <option value="项目验收">项目验收</option>
      </select>
      <input type="text" name="keyword" size="20" value="<%=nowkeyword%>">
      <input type="submit" value=" 查询 " class="button">&nbsp;
    </td>
  </tr>
</form>  
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#C4D8ED">
<tr>
<td><img src="../images/r_1.gif" alt="" /></td>
<td width="100%" background="../images/r_0.gif">
  <table cellpadding="0" cellspacing="0" width="100%">
    <tr>
      <td>&nbsp;项目反馈问题管理
     
      </td>
      <td align="right"> </td>
    </tr>
  </table>
</td>
<td><img src="../images/r_2.gif" alt="" /></td>
</tr>
<tr>
<td></td>
<td>
<form name="form1" action="huiyuan_del.asp">
  <input type="hidden" name="form" value="<%=request("form")%>">
  <input type="hidden" name="field" value="<%=request("field")%>">
  <input type="hidden" name="field2" value="<%=request("field2")%>">
  <input type="hidden" name="field3" value="<%=request("field3")%>">
  <input type="hidden" name="page" value="<%=currentpage%>">
  <input type="hidden" name="email" value="<%=nowemail%>">
  <input type="hidden" name="xinbie" value="<%=nowxinbie%>">
  <input type="hidden" name="keyword" value="<%=nowkeyword%>">
  <input type="hidden" name="order1" value="<%=request("order1")%>">
  <input type="hidden" name="order2" value="<%=request("order2")%>">
  <input type="hidden" name="order3" value="<%=request("order3")%>">
  <input type="hidden" name="order4" value="<%=request("order4")%>">
  <input type="hidden" name="order5" value="<%=request("order5")%>">
  <input type="hidden" name="order6" value="<%=request("order6")%>">
  <input type="hidden" name="order7" value="<%=request("order7")%>">
  <input type="hidden" name="order8" value="<%=request("order8")%>">
  <input type="hidden" name="order9" value="<%=request("order9")%>">
  <input type="hidden" name="order10" value="<%=request("order10")%>">
  <input type="hidden" name="order11" value="<%=request("order11")%>">
  <input type="hidden" name="order12" value="<%=request("order12")%>">
  <input type="hidden" name="order13" value="<%=request("order13")%>">
  <input type="hidden" name="order14" value="<%=request("order14")%>">
  <input type="hidden" name="order15" value="<%=request("order15")%>">
    <div align="center">
<table cellspacing="1" class="toptable grid" border="1">
  <tr align="center">
    <td class="category" height="30" nowrap style="background-color: #EEF7FD">
      <span style="font-weight: 400">
      <a href="?order5=<%if request("order5")="asc" then%>desc<%else%>asc<%end if%>&form=<%=request("form")%>&field=<%=request("field")%>&field2=<%=request("field2")%>&field3=<%=request("field3")%>&page=<%=currentpage%>&zu=<%=nowzu%>&xinbie=<%=nowxinbie%>&keyword=<%=nowkeyword%>">
        项目编号</a><a href="?order5=<%if request("order5")="asc" then%>desc<%else%>asc<%end if%>&form=<%=request("form")%>&field=<%=request("field")%>&field2=<%=request("field2")%>&field3=<%=request("field3")%>&page=<%=currentpage%>&zu=<%=nowzu%>&xinbie=<%=nowxinbie%>&keyword=<%=nowkeyword%>" class="title"><%if request("order5")="asc" then%><img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a>
        </span>
    </td>
    <td class="category" nowrap style="background-color: #EEF7FD">
      <span style="font-weight: 400">
      <a href="?order1=<%if request("order1")="asc" then%>desc<%else%>asc<%end if%>&form=<%=request("form")%>&field=<%=request("field")%>&field2=<%=request("field2")%>&field3=<%=request("field3")%>&page=<%=currentpage%>&zu=<%=nowzu%>&xinbie=<%=nowxinbie%>&keyword=<%=nowkeyword%>" class="title">项目名称<%if request("order1")="asc" then%><img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a>
        </span>
    </td>
    <td class="category" nowrap style="background-color: #EEF7FD">
      <span style="font-weight: 400">
      <a href="?order2=<%if request("order2")="asc" then%>desc<%else%>asc<%end if%>&form=<%=request("form")%>&field=<%=request("field")%>&field2=<%=request("field2")%>&field3=<%=request("field3")%>&page=<%=currentpage%>&zu=<%=nowzu%>&xinbie=<%=nowxinbie%>&keyword=<%=nowkeyword%>" class="title">
        负责<%if request("order2")="asc" then%><img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a>
        </span>
    </td>
    <td class="category" nowrap style="background-color: #EEF7FD">
      <span style="font-weight: 400">
      <a href="?order3=<%if request("order3")="asc" then%>desc<%else%>asc<%end if%>&form=<%=request("form")%>&field=<%=request("field")%>&field2=<%=request("field2")%>&field3=<%=request("field3")%>&page=<%=currentpage%>&zu=<%=nowzu%>&xinbie=<%=nowxinbie%>&keyword=<%=nowkeyword%>" class="title">项目稽核/验收反馈内容<%if request("order3")="asc" then%><img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a>
        </span>
    </td>
    <td class="category" nowrap style="background-color: #EEF7FD">
      <span style="font-weight: 400">
      <a href="?order4=<%if request("order4")="asc" then%>desc<%else%>asc<%end if%>&form=<%=request("form")%>&field=<%=request("field")%>&field2=<%=request("field2")%>&field3=<%=request("field3")%>&page=<%=currentpage%>&zu=<%=nowzu%>&xinbie=<%=nowxinbie%>&keyword=<%=nowkeyword%>">
        类别</a><a href="?order4=<%if request("order4")="asc" then%>desc<%else%>asc<%end if%>&form=<%=request("form")%>&field=<%=request("field")%>&field2=<%=request("field2")%>&field3=<%=request("field3")%>&page=<%=currentpage%>&zu=<%=nowzu%>&xinbie=<%=nowxinbie%>&keyword=<%=nowkeyword%>" class="title"><%if request("order4")="asc" then%><img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a>
        </span>
    </td>
    <td class="category" nowrap style="background-color: #EEF7FD">
      <span style="font-weight: 400">
      <a href="?order6=<%if request("order6")="asc" then%>desc<%else%>asc<%end if%>&form=<%=request("form")%>&field=<%=request("field")%>&field2=<%=request("field2")%>&field3=<%=request("field3")%>&page=<%=currentpage%>&zu=<%=nowzu%>&xinbie=<%=nowxinbie%>&keyword=<%=nowkeyword%>">
        期限</a><a href="?order6=<%if request("order6")="asc" then%>desc<%else%>asc<%end if%>&form=<%=request("form")%>&field=<%=request("field")%>&field2=<%=request("field2")%>&field3=<%=request("field3")%>&page=<%=currentpage%>&zu=<%=nowzu%>&xinbie=<%=nowxinbie%>&keyword=<%=nowkeyword%>" class="title"><%if request("order6")="asc" then%><img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a>
        </span>
    </td>
    <td class="category" nowrap style="background-color: #EEF7FD">
      <span style="font-weight: 400">
      <a href="?order7=<%if request("order7")="asc" then%>desc<%else%>asc<%end if%>&form=<%=request("form")%>&field=<%=request("field")%>&field2=<%=request("field2")%>&field3=<%=request("field3")%>&page=<%=currentpage%>&zu=<%=nowzu%>&xinbie=<%=nowxinbie%>&keyword=<%=nowkeyword%>">
        类型</a><a href="?order7=<%if request("order7")="asc" then%>desc<%else%>asc<%end if%>&form=<%=request("form")%>&field=<%=request("field")%>&field2=<%=request("field2")%>&field3=<%=request("field3")%>&page=<%=currentpage%>&zu=<%=nowzu%>&xinbie=<%=nowxinbie%>&keyword=<%=nowkeyword%>" class="title"><%if request("order7")="asc" then%><img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a>
        </span>
    </td>
    <%if fla37="1" or request.Cookies("shiwei_id")="1" then%>
    <td class="category" width="3%" nowrap style="background-color: #EEF7FD"><span style="font-weight: 400">改</span></td>
    <%end if%>
    <%if fla38="1" or request.Cookies("shiwei_id")="1" then%>
    <td class="category" width="2%" nowrap style="background-color: #EEF7FD"><span style="font-weight: 400">删</span></td>
    <%end if%>
    <%if fla17="1" or request.Cookies("shiwei_id")="1" then%>
    <td class="category" width="4%" nowrap style="background-color: #EEF7FD"><span style="font-weight: 400">结</span></td>
    <%end if%>
  </tr>
  <%
  set rs_huiyuan =server.createobject("ADODB.RecordSet")
  sql="select * from huiyuan 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 nowxinbie<>"" then
    sql=sql&" and xinbie="&nowxinbie
  end if
  if nowkeyword<>"" then
    sql=sql&" and (username like '%"&nowkeyword&"%' or card like '%"&nowkeyword&"%' or tel like '%"&nowkeyword&"%' or qq like '%"&nowkeyword&"%' or id_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 id_email "&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,2
  if not rs_huiyuan.eof then
  rs_huiyuan.pagesize=maxrecord
  rs_huiyuan.absolutepage=currentpage
  for currentrec=1 to rs_huiyuan.pagesize
    if rs_huiyuan.eof then
      exit for
    end if
  %>
搜索更多相关主题的帖子: 搜索 request keyword border center 
2010-05-23 23:17
eournet
Rank: 2
等 级:论坛游民
帖 子:103
专家分:26
注 册:2010-5-22
得分:0 
脑袋找破了,也找不到啊
2010-05-25 21:02



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-307896-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.884213 second(s), 8 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved