我想查询数据库中的前n条记录,但我想让n的值为输入用户提交的值.
n=request("num")
select top n * From alldata_news where (url='' or url is null) and xlbid="&id&" order by id desc "
这样做说top附近有错误,我想应该是n不能为变量的原因,有别的方法吗?哪位大哥知道,请次教.

显示前n条记录不用在SQL语句里定义
sql = "select * From alldata_news where (url='' or url is null) and xlbid="&id&" order by id desc "

n=cdbl(request("num"))
for i = 1 to n
...
next

<%

t=0
n=request("num") //用户输入的数值
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="SELECT * from alldata_news where (url='' or url is null) and xlbid="&id&" order by id desc "
rs.Open sql,conn,1,1
if not Rs.eof then
do while not rs.eof
t=t+1
%>
<li>
<%=rs("news")%>
</li>
<%
if t>=n then exit do
rs.movenext
loop
else
response.write "<li>尚无收录</li>"
end if
rs.close
%>

你试试 这个怎么样

晕 有人跑我前面了 这么快啊

楼上的写的比较完整，我的只是大概意思

呵呵,谢谢了.

id=request("id")
n=request("topnew")
response.Write n
set rsAB=Server.CreateObject("Adodb.recordset")
sql="select top 15 * From alldata_news where (url='' or url is null) and xlbid="&id&" order by id desc "

rsAB.open sql,conn1,1,1
page=1
t=0
if not rsAB.eof then
do while not rsAB.eof
t=t+1
call fsolnews(rsAB("id"))

if t>=n then exit do
rsAB.movenext
loop
end if
这个有什么错误,为什么还是显示15条记录.

楼主没有看懂上面两个朋友写的意思。
sql="select top 15 * From alldata_news where (url='' or url is null) and xlbid="&id&" order by id desc "
这样当然是显示15条了。把这个去掉试试。

n肯定是可以为变量的
在ASP中应该是这么写的：
sql = "select top '"&n&"' * From alldata_news where (url='' or url is null) and xlbid="&id&" order by id desc "
在PHP中是：
sql = "select * From alldata_news where (url='' or url is null) and xlbid="&id&" order by id desc limit 0,n"

把top 15去掉啊 或者用楼上的 '"&amp;n&amp;"'