<%'------------------------------搜索数据库----------------------------------------
             key_word=request("keyword")
    sea_category=request("category")
       set Sea_rs=server.CreateObject("ADODB.recordset")
    strSql="select com_name,com_category,com_img,com_pass from [hy_company] where com_pass=1"
    strSql=strSql & "AND com_category like'%"& sea_category &"%'"
       If key_word <> "" Then
                strSql = strSql & " AND com_name Like '%" & key_word & "%'"
                End If
    strSql = strSql & " order by com_id DESC "
    response.Write(strSql)
    Sea_rs.open strSql,conn,1,1
             do while not Sea_rs.bof and Sea_rs.eof
     %>
    <table width="560" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td height="10"></td>
                  </tr>
                  <tr>
                    <td><table width="560" height="60" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td width="24"> </td>
                        <td width="88" align="center" valign="middle"><img src="../images/None_80_80.gif" width="53" height="56"></td>
                        <td width="448" align="left" valign="middle" class="ax13"><%=Sea_rs("com_name")%></td>
                      </tr>
                    </table></td>
                  </tr>
                  <tr>
                    <td height="10"></td>
                  </tr>
                </table>
    <%loop
    Sea_rs.Close
                set Sea_rs=nothing%>
无法查出数据是为什么啊? 我用的是SQL库

do while not Sea_rs.bof and Sea_rs.eof ……………… Sea_rs.MoveNext Loop 应该是这样的循环吧？ 还有就是到SQL Server查询分析器里测试一下楼主显示出来的SQL语句，看看有没有问题。