----- Original Message -----
From: Jim McAtee <[EMAIL PROTECTED]>
To: CF-Server <[EMAIL PROTECTED]>
Sent: Tuesday, April 10, 2001 11:24 AM
Subject: Re: order by random
> I believe the following will work in Access/Jet. There's no doubt a
similar
> function in SQL or other DBs.
>
> SELECT *
> FROM mytable
> WHERE mycolumn = '#myvalue#'
> ORDER BY Rnd(mytableid)
>
> Use any numeric field in the Rnd() function, but a numeric primary key is
> ideal.
>
> Jim
>
>
> ----- Original Message -----
> From: "Javier Woodhouse" <[EMAIL PROTECTED]>
> To: "CF-Server" <[EMAIL PROTECTED]>
> Sent: Monday, April 09, 2001 6:13 PM
> Subject: RE: order by random
>
>
> > I had to do this and the only thing i could figure out was to create 5
> > columms wich i updated regularly and would order by one of the five -
> chosen
> > at random... the columns themselves contained random numbders...
> >
> > That's about as close as i could come.. Hope it helps
> >
> > > -----Original Message-----
> > > From: Tony [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, April 09, 2001 6:24 PM
> > > To: CF-Server
> > > Subject: order by random
> > >
> > >
> > > Hello Everyone,
> > >
> > > Is there a way to sort a column in random order? I thought
> > > something like:
> > >
> > > SELECT * FROM MyTable
> > > WHERE
> > > MyVariable='#myvalue#'
> > > ORDER BY RANDOM
> > >
> > > would output something like
> > >
> > > 1
> > > 2
> > > 3 the first time
> > >
> > > and then
> > >
> > > 1
> > > 3
> > > 2 (varying in order)
> > >
> > > but all it does is say error... If there isn't a way built
> > > into cf/sql to do this does someone have their own method
> > > that they'd be willing to share?
> > >
> > > Thanks,
> > > Tony Hicks
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
