每次从数据库读取一条内容，但是都不要是我已经读取过的。数据库中有100条数据，是固定的。我是这样写的
sql="select top 1 * from table where id<>1 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 and id<>2 order by Rnd("&Rnd()&"-id)"
每次连接都追加一个and id<>的条件。
但是and id<>这个只能到98个，到第99个就出错了。求一个解决方法，谢谢
ASP?数据过滤?WHERE语句写法
------解决方案--------------------
idarr="1,2,3"
select top 1 * from table where id not in(idarr)
------解决方案--------------------
+1
每读一次都累加idarr,同时建议直接把idarr改成数组比较好操作
------解决方案--------------------
把你每次读过的值组成一个数组，然后使用in
也就是：select top 1 * from table where id not in(idarr) 这样的语句