Daniel -
There were some articles on this a few years ago. Most Random functions are not really
random. The sequence is so
long that it appears random to most people.
It sounds like your issue is that seed, or the starting point, is always the same. Try
using the seconds or
milliseconds of the current time as the seed. That is what many seeds used to use.
-brian
Daniel Lancelot wrote:
> I tried to do something similar in SQL, but found that the rnd() function is
> not random enough - I.E. they were ordered in the same order each time. I
> also tried using getdate() as the seed, but as the whole query ran within 1
> ms, the results were still not random.
>
> If anyone has done this sucessfully (i.e - different results each time they
> run) I would be interested...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
