暴秦 丁典 小说:高手来改错(ASP程序)..

<table width="100%" border="1">
<tr>
<%

strSql="Select * From News where News_ID="&request("News_ID")
set rs=server.createobject("adodb.recordset")
rs.open strSql,conn,1,1
dim News_sort,News_Topic,News_user,News_DateAndTime,News_Boby,News_topic_id
News_sort = rs("News_sort")
News_Topic = rs("News_Topic")
News_user = rs("News_user")
News_DateAndTime = rs("News_DateAndTime")
News_Boby = rs("News_Boby")
News_topic_id = rs("News_topic_id")

strSql="Select * From Topic where Topic_ID='" & News_topic_id & "'"
set rs1=server.createobject("adodb.recordset")
rs1.open strSql,conn,1,1
dim Topic_Topic
Topic_Topic = rs1("Topic_Topic")
%>

<td><%=Topic_Topic%></td>

</tr>
<tr>
<td><table width="100%" border="1">
<tr>
<td align="center"><%=News_Topic%></td>
</tr>
<tr>
<td align="center">作者：<%=News_user%>  发表时间：<%=News_DateAndTime%></td>
</tr>
<tr>
<td>    <%=rs("Topic_Topic")%><%=News_topic_id%></td> '用来显示能否正常输出。输出的值对不对。
</tr>
</table>
</td>
</tr>
</table>

补充：rs("Topic_Topic") 里有东西.而且是中文的.
News_ID是新闻的ID 为数字.
News_topic_id 也为数字.

主要是Topic表里的Topic_Topic不显示,其他都正常.

strSql="Select * From Topic where ( Topic_ID=1) Order By Topic_id" (正常)
strSql="Select * From Topic where Topic_ID='" & News_topic_id & "' Order By Topic_id" (错误)

News_topic_id的值在表里是1
<td><%=Topic_Topic%></td>
不能正常显示