随机排序查询访问 [英] Random sorting query Access

问题描述

我正在使用以下简单查询对ms-access数据库进行随机排序:

I'm using this simple query to use a random sorting on a ms-access database:

SELECT pk FROM TABLE ORDER BY Rnd(pk) asc

当我使用Microsoft Access 2010测试它时，它工作正常

And it's working fine when i test it with Microsoft Access 2010

但是，当我使用经典asp调用此查询时，随机排序不起作用.

However, when i call this query using classic asp, random sorting doesn't work.

这是我的代码:

set Rs = Server.CreateObject("ADODB.Recordset")
Rs.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/dbfolder") & "\dbname.mdb"

Rs.Source = "SELECT pk FROM TABLE ORDER BY Rnd(pk) asc"
Rs.CursorType = 3
Rs.CursorLocation = 2
Rs.LockType = 3
Rs.Open()

do while not Rs.eof
    'do stuff
    Rs.Movenext
loop

推荐答案

您只需要"盐"是您的随机生成器:

You just need to "salt" your random generator:

Rs.Source = "SELECT pk FROM TABLE ORDER BY Rnd(-Timer() * [pk]) Asc"

这篇关于随机排序查询访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！