select top6 from news order by id desc 对吗?

[yaochange]

dim rs
n_title=request("n_title")
sql="select top6 from news order by id desc"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
if rs.eof=false then
这段代码有问题吗
sql=select top6 from news order by id desc 对吗?为什么rs.open sql,conn,1,1总是报错
如何控制窗口大小,window.open.....什么显示,什么不显示
请指教

[pimple]

sql="select top 6 from news order by id desc"


window.open('http://www.csdn.net', 'Sample', 'toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=yes,copyhistory=yes,width=790,height=520,left=0,top=0')

[phoenix8122]

sql="select top6,id from news order by id desc"

[pimple]

sql="select top 6 * from news order by id desc"

[lihua9666]

1.
单看sql="select top6 from news order by id desc"没有问题
有dim conn
set conn=server.CreateObject("adodb.connection")吗？

2.Window.open

function FeedbackQuery(FeedbackID)
{
var newPage;
var info;
info="FeedbackQuery.asp?FeedbackID=" + FeedbackID;
newPage=window.open(info,"_blank","top=200,left=200,height=350,width=600,resizable=no,scrollbars=no,status=no,toolbar=no,menubar=no,location=no");
return false;
}

[yaochange]

dim rs
n_title=request("n_title")
sql="select top 6 * from news order by b_id desc"
dim conn
set conn=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
为什么还是错,rs.open sql,conn,1,1这一句

[sunyc]

top 和 6 之间是空格隔开的 Top 6
6 和 id或（*） 之间也是空格的 Top 6 *
必须要有列名或统配符*的。

[sunyc]

="select top 6 * from news order by b_id desc"
看起来是对的。别的我就不知道了。你看看是不是其他方面的问题