有关数据查询的错误,大家过来看一下,怎么解决这个问题?
<%
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