Yeah. It's just really hard to find a decent number for the seed in SQL Server.
-----Original Message----- From: John B. White [mailto:[EMAIL PROTECTED]] Sent: February 13, 2002 2:21 PM To: CF-Talk Subject: Re: Random row from SQL Don't most programs actually have a random number table that they dra w the random numbers from? Then every time you reset the software, they be gin pulling the same random numbers? We got around this one time by using the IP address, stripping the periods...raising to a power of two (or something simil ar) and using the resulting number as the random seed. Still not truly rando m but seemed (at the time 4+ years ago) "more" random. --JW Kwang Suh wrote: > You should know that the random function in SQL Server really, real ly > sucks. > Unless you can seed it with a number that changes constantly every ti > me > before you call the function, you'll get lots of unrandom numbers. _____________________________________________________________________ _ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
