Subject Re: [ib-support] select Random-records
Author Ann W. Harrison
At 06:30 PM 9/7/2001 +0300, raptor wrote:
>:") ok... I want to use this so that i can display randomly ads on the
>web-pages (from all available)....


Had I known that I wouldn't have answered in the first place! Databases
are designed to curb the randomness of the world, so they're not very
good a producing random results - you tend to see lots of artifacts of
storage. My suggestion is that you use a random number generator to
create pointers into an array whose upper bound is the current gen_id
value. Sometimes you'll hit a hole, but ...


Regards,

Ann
www.ibphoenix.com
We have answers.