-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hmm... If all you're looking for is a random order of the resultset, try this out. Select * from INFORMATION_SCHEMA.tables ORDERY BY NEWID() Will always return a random order, even if the select is submitted in the same batch (and effectively at the same time). I know this original post was about Access, but hopefully Brian and Daniel will find this snippet useful. :) Joe ============================================== Joseph Cruz Programmer/Analyst Wharton Computing 3620 Locust Walk, Suite 400 Philadelphia, PA 19104-6302 (215) 898-1220 (w) (215) 308-0657 (p) (215) 768-2071 (m) [EMAIL PROTECTED] ============================================ > -----Original Message----- > From: Brian Hogue [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 22, 2001 3:33 PM > To: SQL > Subject: Re: [Fw: order by random] > > > 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... -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA/AwUBOwrTF9CGp5RuWHIBEQJYlQCgyQBMYXn2tKR0pwmm2cAq1tuju6EAoIte du2hysMe62oBUTUu1isIywH4 =2fpX -----END PGP SIGNATURE----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
