sql = "select * from replies where art_id = "&art_id&" order by issue_time ASC"

sql = "select * from topices where art_id = "&art_id&" order by issue_time ASC"

两个都可以显示

但是 sql = "select * from replies,topices where art_id = "&art_id&" order by issue_time ASC"

却不可以显示

错误是错误类型： Microsoft JET Database Engine (0x80004005) /ASP/replyTheme.asp, 第 40 行 就是RS.OPEN SQL,CNN 错误了

请问该怎么办？？？

你两个表不联接一下？有两个表的时候字段名前要加表名。

sql = "select * from replies,topices where replies.art_id =topices.art_id and topices.art_id="&art_id&" order by topices.issue_time ASC"

谢谢拉

<% do until rs.eof response.write "<tr>" response.write "<td width='20%' bordercolor='#FF0000'>" response.write rs("author") response.write "</td>" response.write "<td width='80%' bordercolor='#FF0000'>" response.write rs("content") response.write "</td>" response.write "</tr>" rs.moveNext loop %>

上面的这些这么改？

显示不了

rs.("author")

<% response.write "<tr>" response.write "<td width='20%' bordercolor='#FF0000'>" response.write rs("topices.author") response.write "</td>" response.write "<td width='80%' bordercolor='#FF0000'>" response.write rs("topices.content") response.write "</td>" response.write "</tr>" rs.moveNext do until rs.eof response.write "<tr>" response.write "<td width='20%' bordercolor='#FF0000'>" response.write rs("replies.author") response.write "</td>" response.write "<td width='80%' bordercolor='#FF0000'>" response.write rs("replies.content") response.write "</td>" response.write "</tr>" rs.moveNext loop %>

我自己改成这个样子了

现在可以了

呵呵