关于MS SQL 筛选调用问题。
[code]<%set rs=server.createobject("adodb.recordset")sql="select top 10 * from NewsReview where Audit>0 order by NewsReviewID desc"
rs.open sql,conn,1,1
do while not rs.eof
content = Trim(rs("content"))
contentshow = Trim(rs("content"))
UserID = Trim(rs("UserID"))
NewsReviewID = Trim(rs("NewsReviewID"))
Newsarticleid = Trim(rs("Newsarticleid"))
If len(contentshow) >50 then
contentshow =left(contentshow,50)&".."
End if
If len(content) >22 then
content =left(content,22)&".."
End if
%>
<tr>
<td height="23"><div align="left">·<a href="../NewsHtml/<% =filepath%>/<% =Newsarticleid%>_1.htm"
title="<% =contentshow%>" target="_blank">
<% =content%>[/code]以上调用是数据库表：NewsReview 的数据，而<% =filepath%> 是数据库表：NewsArticle字段。
我想调用用数据库表：NewsArticle里<% =filepath%>字段怎么调用？？？
两个表相同的字段为：Newsarticleid
sql="select top 10 * from NewsReview where Audit>0 order by NewsReviewID desc"
怎么写啦。。兄弟帮帮忙啦。。哈哈。。
页:
[1]