http://www.cflib.org/udf.cfm/QueryRandomRows
It works AFTER you've gotten your query recordset from the database.
-nathan strutz
http://www.dopefly.com/
James Smith wrote:
> Is there any way to randomise a query result set? I was thinking of
> adding...
>
> SELECT rand() AS RandomColumn, OtherQueryFields, .......
> FROM .......
> WHERE .......
> ORDER BY RandomColumn
>
> to the query but am not sure if this will produce a good randomisation, it
> doesn't need to be perfect, just good.
>
> I am selecting about 800-900 records of which 400-800 will be used (don't
> ask!) and I need to make sure that (on average) they are all used.
>
> --
> James Smith
> [EMAIL PROTECTED]
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
