| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 576 人关注过本帖
标题:请教一个错误问题(至少有一个值没有被指定)
只看楼主 加入收藏
eournet
Rank: 2
等 级:论坛游民
帖 子:103
专家分:26
注 册:2010-5-22
结帖率:55.56%
收藏
已结贴  问题点数:10 回复次数:3 
请教一个错误问题(至少有一个值没有被指定)
'取得搜索关键字  
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
hams
Rank: 12Rank: 12Rank: 12
等 级:贵宾
威 望:18
帖 子:912
专家分:3670
注 册:2008-7-30
收藏
得分:3 
写入之前先显示一下看看

俺不高手,俺也是来学习的。
俺的意见不一定就对,当你不认同时请点忽视按钮。
当走到十字路口不知该如何走时,可在论坛问下路,但你若希望别人能一路把你送到目的地,显然是不现实的,因为别人也有自己要走的路。
2010-05-24 09:01
gupiao175
Rank: 16Rank: 16Rank: 16Rank: 16
等 级:版主
威 望:40
帖 子:1787
专家分:7527
注 册:2007-6-27
收藏
得分:3 
你的sql好长啊,response.write sql
输出看看是否有什么不完整的地方,最好输出后直接拿到数据库执行,以判断是否有什么变量丢失!

Q:1428196631,百度:开发地 即可找到我,有事请留言!
2010-05-25 12:19
eournet
Rank: 2
等 级:论坛游民
帖 子:103
专家分:26
注 册:2010-5-22
收藏
得分:0 
脑袋找破了,也找不到啊
2010-05-25 21:02
快速回复:请教一个错误问题(至少有一个值没有被指定)
数据加载中...
 
   



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

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