How would I go about selecting a random recordset from a database? I look on a lot of website, and just cant find anything... Any help would be great!

???

AND

sql = "SELECT someField FROM sometable WHERE someVariable <> someOterVariable;"

comes to mind, could you elaborate a little more?

Wind is your friend
Matt

Hmmmm,
Not sure if there is any method for this in MS SQL, but the SQL forums may be able to help with that.
If I was to do this in ASP I would probably load an array with all the primary keys in the table.
Then randomly select the array index.
This is my fisrt though on this, others may have better way.

Or count the records, then randomly select an int between 1 and the count and iterate through the key recordset the random number of times, then that is your random PK.

Basically the same just skips the array.

Rod



======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

Of course you could select one or many random array indexes or random count values.


======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

Can you explain a bit more on this.

_________________________
- Vijay G
Strive for Perfection

It really depends on which db you're using.

In SQL Server you can do it easily using the NEWID() function:
select top <<number>> * from <<yourtable>> order by newid()

Access is a bit trickier, but can be done using the Rnd() function,
see http://www.adopenstatic.com/faq/RandomRecord.asp