标题:懂点ASP的都来看看,可能是小问题!
只看楼主
renjiming
Rank: 1
等 级:新手上路
帖 子:2
专家分:0
注 册:2005-3-3
 问题点数:0 回复次数:2 
懂点ASP的都来看看,可能是小问题!
我自己用ASP弄的一个搜索功能
为什么在主页上好使~
在别的页面上我把主页上搜索代码拷贝过来。然后搜索第一次什么也搜索不到~
再点搜索就能搜索到~这是为什么啊~谁能告诉我啊?

这是那个代码~  第一次什么都搜索不着,再点一次就能搜索到结果~不知道为什么
 
<select name="txtDiduan" size="1" class=f11>
                      <option selected value="%">--不限--</option>
                      <%dim rs2,sql2,sel
                          set rs2=server.createobject("adodb.recordset")
                          sql2="select * from fctype"
                          rs2.open sql2,conn,1,1                  
                     
                     do while not rs2.eof
        if typeID=cstr(rs2("typeID")) then
               sel="selected"
        else
               sel=""
         
        response.write "<option " & sel & " value='" +  Cstr(rs2("type")) + "'>" + rs2("type") + "</option>"
       rs2.movenext
   end if   
 loop
rs2.close
%>
                    </select>
                  </span><span class=9size> <span style="font-size: 9pt"> </span> </span></td>
                </tr>
                <tr>
                  <td height="26" valign="bottom"><span class=9size> <span style="font-size: 9pt"> </span><span style="font-size: 9pt" id="fps0">   面积: </span><span style="font-size: 9pt" id="fps4"> </span><span style="font-size: 9pt" id="fps0">
                    <select name=txtMianj class=form>
                      <option value=% selected>---不 限---</option>
                      <option value=A>50平方以下</option>
                      <option value=B>50-70平方</option>
                      <option value=C>70-90平方</option>
                      <option value=D>90-110平方</option>
                      <option value=E>110-150平方</option>
                      <option value=F>150平方以上</option>
                    </select>
                  </span><span style="font-size: 9pt"> </span><span style="font-size: 9pt"> </span> </span></td>
                </tr>
                <tr>
                  <td height="26" valign="bottom"><span class=9size> <span style="font-size: 9pt"> </span><span style="font-size: 9pt" id="fps0">   总价: </span><span style="font-size: 9pt" id="fps5"> </span><span style="font-size: 9pt" id="fps1">
                    <select name=txtJiag class=form>
                      <option value=% selected>---不 限---</option>
                      <option value=A>8万以下</option>
                      <option value=B>8-10万</option>
                      <option value=C>10-12万</option>
                      <option value=D>12-15万</option>
                      <option value=E>15-20万</option>
                      <option value=F>20-25万</option>
                      <option value=G>25-30万</option>
                      <option value=H>30-40万</option>
                      <option value=I>40-50万</option>
                      <option value=J>50-100万</option>
                      <option value=K>100-200万</option>
                      <option value=L>200万以上</option>
                    </select>
                  </span><span style="font-size: 9pt"> </span><span style="font-size: 9pt"> </span> </span></td>
                </tr>
                <tr>
                  <td height="26" valign="bottom"> <span class=9size><span style="font-size: 9pt"> </span><span style="font-size: 9pt" id="fps0">   时间: </span><span style="font-size: 9pt" id="fps6"> </span><span style="font-size: 9pt" id="fps2">
                    <select name=txtsj class=form>
                      <option value=3600 selected>---不 限---</option>
                      <option value=7>七天内信息</option>
                      <option value=15>半月内信息</option>
                      <option value=30>一月内信息</option>
                      <option value=90>三月内信息</option>
                    </select>
                  </span><span style="font-size: 9pt"> </span><span style="font-size: 9pt"> </span> </span> </td>
                </tr>
搜索更多相关主题的帖子: ASP 
2005-03-03 21:00
renjiming
Rank: 1
等 级:新手上路
帖 子:2
专家分:0
注 册:2005-3-3
得分:0 
为什么没人回复呢~~我这个问题很难吗?????
2005-03-04 19:28
mu256
Rank: 1
等 级:新手上路
帖 子:29
专家分:0
注 册:2005-3-5
得分:0 
把收缩的sql语句贴出来看看

gi_gi698@
2005-03-05 17:26



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




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

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