有关数据查询的错误，大家过来看一下，怎么解决这个问题？
<%
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( "companyname1 ")%> </td>
<td width= "15% " align= "right " bgcolor= "#F6F6F6 "> 法人传真： </td>
<td width= "34% " align= "left " bgcolor= "#FFFFFF "> <%=rs( "personfax1 ")%> </td>
</tr>
<tr>
<td height= "26 " align= "right " bgcolor= "#F6F6F6 "> 性质： </td>
<td height= "26 " align= "left " bgcolor= "#FFFFFF "> <%=rs( "character1 ")%> </td>
<td height= "26 " align= "right " bgcolor= "#F6F6F6 "> 联系人： </td>
<td height= "26 " align= "left " bgcolor= "#FFFFFF "> <%=rs( "linkman1 ")%> </td>
</tr>
<tr>
<td height= "25 " align= "right " bgcolor= "#F6F6F6 "> 地址： </td>
<td height= "25 " align= "left " bgcolor= "#FFFFFF "> <%=rs( "address1 ")%> </td>
<td height= "25 " align= "right " bgcolor= "#F6F6F6 "> 联系人电话： </td>
<td height= "25 " align= "left " bgcolor= "#FFFFFF "> <%=rs( "linkmanphone1 ")%> </td>
</tr>
<tr>
<td height= "25 " align= "right " bgcolor= "#F6F6F6 "> 邮编： </td>
<td height= "25 " align= "left " bgcolor= "#FFFFFF "> <%=rs( "number1 ")%> </td>
<td height= "25 " align= "right " bgcolor= "#F6F6F6 "> 联系人传真： </td>
<td height= "25 " align= "left " bgcolor= "#FFFFFF "> <%=rs( "linkmanfax1 ")%> </td>
</tr>
<tr>
<td height= "25 " align= "right " bgcolor= "#F6F6F6 "> 法定代表人： </td>
<td height= "25 " align= "left " bgcolor= "#FFFFFF "> <%=rs( "person1 ")%> </td>
<td height= "25 " align= "right " bgcolor= "#F6F6F6 "> E-mail： </td>
<td height= "25 " align= "left " bgcolor= "#FFFFFF "> <%=rs( "linkmanemail1 ")%> </td>
</tr>
<tr>
<td height= "25 " align= "right " bgcolor= "#F6F6F6 "> 法人电话： </td>
<td height= "25 " align= "left " bgcolor= "#FFFFFF "> <%=rs( "personphone1 ")%> </td>
<td height= "25 " align= "right " bgcolor= "#F6F6F6 "> 网页或网址： </td>
<td height= "25 " align= "left " bgcolor= "#FFFFFF "> <%=rs( "personweb ")%> </td>
</tr>
<tr>
<td height= "25 " align= "right " bgcolor= "#F6F6F6 "> </td>
<td height= "25 " align= "left " bgcolor= "#FFFFFF "> </td>
<td height= "25 " align= "right " bgcolor= "#F6F6F6 "> QQMSN： </td>
<td height= "25 " align= "left " bgcolor= "#FFFFFF "> <%=rs( "QQMSN ")%> </td>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
这些数据都是在表baojia中,只是loop以上的数据是这家公司发布的信息.发布的信息要都显示出来所以要用loop,下边是显示这家公司的联系信息只显示一次就可以了
郊果像这们
公司 内容
AA ddddd
AA jjkkkk
AA llllll
下边显示的公司的联系信息从数据库中提出来的
公司地址
公司电话等等
怎么解决这个 问题。。上边的代码不正确，出现未知错误。。。
[解决办法]
还有个疑问，你的表是不是设计得有很大的问题啊
一个一对多的关系怎么会放在一个表里呢，你不觉得数据冗余很大吗
分开来吧
1.公司信息表
公司代码（主键）
公司名称
公司地址
等等
2.报价表
公司代码（外键）
产品
价格
等等
两个表有公司代码连接
