Michael,
I think you may have solved my problem. We're still experimenting with it but I
think setseed is going to work. Thank you very, very much!
Jeff Herrin
- Original Message -
From: Michael Fuhr <[EMAIL PROTECTED]>
To: Jeff Herrin <[EMAIL PROTECTED]>
Cc: Andreas K
12:27:42 PM GMT-0500 US/Eastern
Subject: Re: [SQL] consistent random order
Jeff Herrin <[EMAIL PROTECTED]> schrieb:
> I am returning results ordered randomly using 'order by random()'. My issue
> has
> to do with page numbers in our web application. When I hit the 2nd
I need it a little more random than that. In both these scenarios, the same
items will always follow each other.
Jeff
- Original Message -
Why not create a random seed between 1 and the number of possibilities in your
web application when a user first hits the site, store that in the
random set. That way, when I get to the 2nd page, i know i'm getting the
dataset back in the same order that I had on page 1, and the offset works like
normal. Is this even realistically possible?
Thanks,
Jeff Herrin