Re: [sqlite] RE: [RBL] Re: [sqlite] Randomly ordering results

2006-01-18 Thread Jay Sprenkle
On 1/18/06, Steve O'Hara <[EMAIL PROTECTED]> wrote: > if you did, then you'd notice that for regression testing, a flag is set > that forces the random() function to be seeded on the same number each > time. I hope it's a run time flag... ;) Thanks for the info.

Re: [sqlite] RE: [RBL] Re: [sqlite] Randomly ordering results

2006-01-17 Thread Jay Sprenkle
On 1/17/06, Steve O'Hara <[EMAIL PROTECTED]> wrote: > Jay, If you're going to offer advice, at least do some basic research to > make sure it's accurate. Was it your intent to be insulting or are you just drunk? > > Firstly, having a column that has a random number in it and sorting by > it

[sqlite] RE: [RBL] Re: [sqlite] Randomly ordering results

2006-01-17 Thread Steve O'Hara
Jay, If you're going to offer advice, at least do some basic research to make sure it's accurate. Firstly, having a column that has a random number in it and sorting by it produces the same output each time you query on it - obviously unsatisfactory and I would have thought, manor from heaven for