日期:2014-05-17  浏览次数:20989 次

有关数据查询的错误,大家过来看一下,怎么解决这个问题?
<%
set   rs=server.createobject( "adodb.recordset ")
sql= "select   *   from   baojia   where   gongshi= ' "&   request( "gongshi ")   & " ' "
rs.open   sql,conn,1,1  
do   until   rs.eof
%>
<table   width= "98% "   cellpadding= "1 "   cellspacing= "1 "   border= "0 ">
            <tr   bordercolor= "#D4D0C8 "   bgcolor= "#EEEEEE ">
                <td   width= "16% "   height= "20 "> <div   align= "center "> <%=rs( "gongshi ")%> </div> </td>
                <td   width= "7% "   height= "20 "> <div   align= "center "> <%=rs( "pin ")%> </div> </td>
                <td   width= "11% "> <div   align= "center "> <%=rs( "gui ")%> </div> </td>
                <td   width= "14% "> <div   align= "center "> <%=rs( "jia ")%> </div> </td>
                <td   width= "9% "> <div   align= "center "> <%=rs( "jie ")%> </div> </td>
                <td   width= "16% "> <div   align= "center "> <%=rs( "jiao ")%> </div> </td>
                <td   width= "12% "> <div   align= "center "> <%=rs( "chan ")%> </div> </td>
                <td   width= "15% "> <div   align= "center "> <%=rs( "youdate ")%> </div> </td>
            </tr>
        </table>
<%
rs.movenext
loop
%>
</div>
            <div   id= "wezi ">
                <hr   size= "1 "   color= "#EAEAEA "   width= "100% ">
      <span   class= "STYLE1 "> 以下为公司联系方式 </span>
      <table   border= "0 "   align= "center "   cellpadding= "0 "   cellspacing= "0 "   width= "100% "   id= "tddd ">
          <tr>
                                              <td   width= "15% "   height= "25 "   align= "right "   bgcolor= "#F6F6F6 "> 公司名: </td>
                      <td   width= "36% "   align= "left "   bgcolor= "#FFFFFF ">   <%=rs( &qu