Question

asp mdb 数据库 从第N条记录开始读取 语法错误问题

用语句
rs.open"select * from tmmm where id not in (select top 150 id from tmmm order
by id asc)",con,1,1
从表 tmmm 从第150记录开始读取没问题，

现在改成这样：
dim n
n=150
rs.open"select * from tmmm where id not in (select top n id from tmmm order
by id asc)",con,1,1

错误提示：
Microsoft JET Database Engine '80040e14'
语法错误。 在查询表达 式 'id not in (select top n id from tmmm order by id asc)' 中。
\返回记录数.asp, line 11

这样就出现语法错误了，请问：变量n要怎样写进语句才正确？

Answer 1

dim n
n=150
rs.open "select * from tmmm where id not in (select top " & n & " id from tmmm order
by id asc)",con,1,1