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 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]
