thats more than id like to have on a cfm template.
why not put that logic on the data layer?
tw
On Tue, 28 Sep 2004 13:23:52 -0700, Nathan Strutz <[EMAIL PROTECTED]> wrote:
> There's a UDF for that...
>
> http://www.cflib.org/udf.cfm/QueryRandomRows
>
> It works AFTER you've gotten your query
There's a UDF for that...
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 r
SELECT TOP 900 *
FROM Table
WHERE foo=bar
ORDER BY NEWID()
From: James Smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 28, 2004 10:16 AM
To: CF-Talk
Subject: Randomising a query
Is there any way to randomise a query result set? I was thinking of
addin
you can always use...
select *
from myTable
order by newid()
that will select everything from that table (not recommended, but for
this purpose it will work)
the order by newid()
will create a new UUID for each row, and of course, but doing so, will make it
a random result set as those are VERY
4 matches
Mail list logo