武林外传剑系和枪系:ASP 数据库查询问题求救/////////!!!!!!!!!

来源:百度文库 编辑:高考问答 时间:2024/05/09 04:53:22
<%

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 rs=server.createobject("adodb.recordset")
rs.open strSql,conn,1,1
dim Topic_Topic
Topic_Topic = rs("Topic_Topic")
%>

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

<%=Topic_Topic%>死活不显示.
二楼的老兄不行啊.

你在<td><%=Topic_Topic%></td>
后面加上
<%
rs.close
conn.close
%>
刚才还没有仔细看看,你怎么用了两个rs,你用两个recordset的话取不一样的名字,而且用完了之后记得要有close