ASP初学者继续求职 _ASP

ASP菜鸟继续求职
代码：

HTML code

    
 <td  align="center"><nobr><%sql="select tb_jxlsb.*,tb_faculty.xsmcheng from tb_jxlsb,tb_faculty where tb_faculty.xsdhao=yxsh order by jsbhao"
rs1.open sql,con,1,1
if not rs1.eof then
   do while not rs1.eof 
%> 

[color=#FF0000]<%=rs1("xsmcheng")%>[/color]

  <%rs1.movenext
  loop
end if
rs1.close
  %></nobr></td>

我想要在<td>里面出现红色的那个字段怎么写

------解决方案--------------------
看看con是你的数据库连接吗